How can I set a default schema for a session

From: "Dilan Arumainathan" <dilan_a(at)impark(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: How can I set a default schema for a session
Date: 2003-07-22 20:52:22
Message-ID: CFEJJBOGEDDKJMNKNGAPOEHHEEAA.dilan_a@impark.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David Olbersen 2003-07-22 20:54:09 Re: pg_restore problem!!!
Previous Message Nick Fankhauser 2003-07-22 20:29:33 Re: pg_restore problem!!!