Re: Set search_path for session

On Fri, Apr 17, 2009 at 8:47 AM, Mary Sipple <msipple(at)iii(dot)com> 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';