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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
