Postgres Pro
Downloads
Home   >   mailing lists

How can I set a default schema for a session - Mailing list pgsql-admin

From Dilan Arumainathan
Subject How can I set a default schema for a session
Date
Msg-id CFEJJBOGEDDKJMNKNGAPOEHHEEAA.dilan_a@impark.com
Whole thread Raw
In response to Re: pg_restore problem!!!  ("Nick Fankhauser" <nickf@ontko.com>)
Responses Re: How can I set a default schema for a session  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: How can I set a default schema for a session  (Ian Barwick <barwick@gmx.net>)
List pgsql-admin
Tree view 
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?

thanks
dilan

pgsql-admin by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: pg_restore problem!!!
Next
From: "David Olbersen"
Date:
Subject: Re: pg_restore problem!!!