tags:

views:

57

answers:

2

I want to set the default search_path to something other than the "public" schema. But I only want to do this for a particular user. How can I accomplish this?

A: 

I found the answer:

ALTER USER username SET search_path = schema1,schema2,schema3,etc;

Jin Kim
+2  A: 

Did you see the accepted answered here ?

leonbloy
No I didn't. Thanks.
Jin Kim