On Fri, Apr 17, 2009 at 8:47 AM, Mary Sipple <msipple@xxxxxxx> wrote: > We have a script wrapper for psql which reads a configuration file and > constructs a psql command to connect to the configured instance of postgres. > We would like to include a search_path setting in the configuraration file > and have the wrapper use that to set the search_path for the psql session. I > tried using the -v flag (-vsearch_path=xxxx) with the psql command but that > did not work: > Can anyone tell me how I can make this happen short of changing the > search_path setting in postgresql.conf & restarting postgres? You can also alter user or database as well. alter user abc set search_path='xyz','public'; -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general