Add schema resolution to PostgreSQL operations

Also fill out test cases for PostgreSQL-specific tests.