From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-admin@postgresql.org
Subject: Re: SET search path
Date: Mon, 31 Oct 2011 11:14:45 +0300
User-Agent: KMail/1.9.7
References: <04DA5C9AF2453F44ACD4541A08EFE9832FFC005000@MUSCA.onmobile.com>
In-Reply-To: <04DA5C9AF2453F44ACD4541A08EFE9832FFC005000@MUSCA.onmobile.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <201110311014.45633.achill@matrix.gatewaynet.com>

=CE=A3=CF=84=CE=B9=CF=82 Sunday 30 October 2011 12:34:38 =CE=BF/=CE=B7 Akas=
h Kodibail =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Hi,
>=20
> I am using postgresql 8.4.0
>=20
> Select version() gives:
>=20
> PostgreSQL 8.4.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3=
=2E4.6 20060404 (Red Hat 3.4.6-10), 64-bit
>=20
> I have trying to set search path, so that I do not have to append the sch=
ema_name while doing a select on the tables, however, when I do so, the sea=
rch_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.
>=20
> After I do a set search_path, pg_user view does not show any entry in the=
 column "useconfig" for the same being set.
>=20
As superuser
ALTER user username set search_path TO "$user",someschema,public ;=20
works in 8.3 and 9.*

> Regards,
> Akash.
>=20
> ________________________________
> DISCLAIMER: The information in this message is confidential and may be le=
gally privileged. It is intended solely for the addressee. Access to this m=
essage by anyone else is unauthorized. If you are not the intended recipien=
t, any disclosure, copying, or distribution of the message, or any action o=
r omission taken by you in reliance on it, is prohibited and may be unlawfu=
l. Please immediately contact the sender if you have received this message =
in error. Further, this e-mail may contain viruses and all reasonable preca=
ution to minimize the risk arising there from is taken by OnMobile. OnMobil=
e 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 befo=
re opening this e-mail or any attachment thereto.
> Thank you - OnMobile Global Limited.
>=20


=2D-=20
Achilleas Mantzios