On Tue, 22 Jul 2003, Dilan Arumainathan wrote:
> Hi,
> Every time I have to specify a table name in a query I find myself prefixing
> the name of the table with the schema name as in schema.table. Is there a
> way to force the queries to look in one particular schema whenever I do not
> specify a schema name?
Just change search_path to include it:
psql
> set search_path=$user,public,mynewschema;