Add PostgreSQL logic for loading/dumping a SQL schema

This adds the logic needed to properly load and dump a SQL schema
using the PostgreSQL adapter. This runs the `pgsql` and `pg_dump`
commands to achieve this. This logic isn't tested because we don't
have automated tests for any logic that requires accessing the DB.
I've loaded this with an application using PostgreSQL to confirm it
works.