Re: How can I set a default schema for a session

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;