In article <201110311014.45633.achill@xxxxxxxxxxxxxxxxxxxxx>, Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> 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; -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
