Re: [GENERAL] Set search_path for session

2009-04-20 Thread Mary Sipple
Thanks everyone! A follow up question: Is there any way to set the search_path to all existing schemas? I'm looking for some kind of wild card method that will automatically pick up every schema. Thanks, Mary -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

[GENERAL] Set search_path for session

2009-04-17 Thread Mary Sipple
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.

Re: [GENERAL] Set search_path for session

2009-04-17 Thread Scott Mead
On Fri, Apr 17, 2009 at 10:47 AM, Mary Sipple msip...@iii.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

Re: [GENERAL] Set search_path for session

2009-04-17 Thread Scott Mead
On Fri, Apr 17, 2009 at 10:47 AM, Mary Sipple msip...@iii.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

Re: [GENERAL] Set search_path for session

2009-04-17 Thread Alvaro Herrera
Mary Sipple 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

Re: [GENERAL] Set search_path for session

2009-04-17 Thread Scott Marlowe
On Fri, Apr 17, 2009 at 8:47 AM, Mary Sipple msip...@iii.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