-------------- Original message ---------------------- From: "Masis, Alexander (US SSA)" <[EMAIL PROTECTED]> > I have to explicitly specify the schema name to make SQL statement to > work. > Can I set the schema before the query, or set a default schema? > My current statement: > "SELECT col FROM schema.table" > I like to be able to use generic SQL statement like: > "SELECT col FROM table" > > > > -- See search_path in: http://www.postgresql.org/docs/8.3/interactive/runtime-config-client.html
-- Adrian Klaver [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general