Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How can I set a default schema for a session
- From: Ian Barwick <barwick(at)gmx(dot)net>
- To: "Dilan Arumainathan" <dilan_a(at)impark(dot)com>, <pgsql-admin(at)postgresql(dot)org>
- Subject: Re: How can I set a default schema for a session
- Date: Tue, 22 Jul 2003 23:18:58 +0200
- Message-id: <200307222318.58234.barwick@gmx.net> <text/plain>
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
- References:
- How can I set a default schema for a session
- From: Dilan Arumainathan
- How can I set a default schema for a session
- Prev by Date: Re: pg_restore problem!!!
- Next by Date: Re: Replication/Failover/HA solution
- Previous by thread: Re: How can I set a default schema for a session
- Next by thread: Re: pg_restore problem!!!
- Indexes: