Setting Session Authorization and Search Path

Posted on August 24, 2011 by admin

SET SESSION AUTHORIZATION jane;
SET search_path = schema1,schema2, schema3;
SELECT * FROM any_table_in_schema_1_2_or_3;

This entry was posted in Database, PostgreSQL. Bookmark the permalink.