Setting Session Authorization and Search Path

Written by

in

,

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

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *