Στις 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.*
> Regards, > Akash. > > ________________________________ > DISCLAIMER: The information in this message is confidential and may be > legally privileged. It is intended solely for the addressee. Access to this > message by anyone else is unauthorized. If you are not the intended > recipient, any disclosure, copying, or distribution of the message, or any > action or omission taken by you in reliance on it, is prohibited and may be > unlawful. Please immediately contact the sender if you have received this > message in error. Further, this e-mail may contain viruses and all reasonable > precaution to minimize the risk arising there from is taken by OnMobile. > OnMobile is not liable for any damage sustained by you as a result of any > virus in this e-mail. All applicable virus checks should be carried out by > you before opening this e-mail or any attachment thereto. > Thank you - OnMobile Global Limited. > -- Achilleas Mantzios -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
