adapter-specific `drop_tables` helper

This moves the adapter-specific behavior in `drop_tables` into the
adapters.  Right now it is only supported in the Postgres adapter.

This picks up on work in #27.

@jcredding ready for review.