Re: SET search path

In article <201110311014(dot)45633(dot)achill(at)matrix(dot)gatewaynet(dot)com>,
Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> writes:

> Στις Sunday 30 October 2011 12:34:38 ο/η Akash Kodibail έγραψε:
>> Hi,
>>
>> I am using postgresql 8.4.0
>>
>> Select version() gives:
>>
>> PostgreSQL 8.4.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-10), 64-bit
>>
>> I have trying to set search path, so that I do not have to append the schema_name while doing a select on the tables, however, when I do so, the search_path is set only for that session, it is not a permanent change that is done. Can you please guide me as to how to make it permanent.
>>
>> After I do a set search_path, pg_user view does not show any entry in the column "useconfig" for the same being set.
>>
> As superuser
> ALTER user username set search_path TO "$user",someschema,public ;
> works in 8.3 and 9.*

This sets the search path even if this user connects to another database
without someschema. Therefore I prefer

ALTER DATABASE dbname SET search_path TO public,someschema;