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

On Tuesday 22 July 2003 22:52, 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?

SET search_path TO ...

http://www.postgresql.org/docs/7.3/static/ddl-schemas.html

You can also use

ALTER USER user_name SET search_path to ...;

to make the setting permanent.

Ian Barwick
barwick(at)gmx(dot)net