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; ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
