support schema creation for psql platform

This implements handling schema creation for PostgreSQL, similar to #328, but platform-specific code is in the appropriate class. Tests included.