-------------- Original message ----------------------
From: "Masis, Alexander (US SSA)" <alexander.masis@baesystems.com>
> 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
aklaver@comcast.net