Re: Set search_path

#1

"Michael A Weber" <mweber (AT) 4wre (DOT) com> writes:

Quote:

If I attempt to do a query of, say Select * from Users, it fails with
'relation "users" does not exist.

And you think this is wrong why? You haven't mentioned creating such a
table in schema newpath ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#2

On May 14, 2004, at 7:11 PM, Michael A Weber wrote:

Quote:

Is there a way to make it ‘stick’ as it seems that it isn’t sticking?*
Or, am I missing something completely?* Please help!

set search_path simply sets it for your current session.

To set it permanently, do alter user username set search_path = newpath;

Jeff

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Set search_path

comp.databases.postgresql.novice comp.databases.postgresql.novice

Re: Set search_path - 05-21-2004 , 10:17 AM

Re: Set search_path - 05-21-2004 , 09:52 PM