I've never tried that, but have you experimented with setting the schema
from the .psqlrc file? If you can do that then you might be able to get
.psqlrc to set the schema to a variable which you have set using the -v
It's just a thought ... I've never tried.
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of
Sent: 12 April 2007 14:57
Subject: [NOVICE] Setting schema from command line in psql
I keep a large number of separate development projects in a single
database, each in its own schema. Whenever I wish to work on one of them
in psql, after running
I then have to type
SET search_path TO <schemaname> [, PUBLIC] ;
I would really like to be able to do this from the command line, so that
I can make a wrapper for it, something like 'openproject <pname>'.
I read through the manual and the closest thing I could find was --set,
but this handles psql environment variables, which do not, as far as I
can see, affect the search_path.
Ideally I would like something like this:
psql --schema <schemaname> <- pg_dump already supports this
Or, perhaps better:
psql --before-starting-execute-this-command "SET search_path....
(or a similar more digestable syntax)
Have I missed something in the docs ?
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
In response to
pgsql-novice by date
|Next:||From: psql-novice||Date: 2007-04-12 16:41:37|
|Subject: Re: Setting schema from command line in psql|
|Previous:||From: Tom Lane||Date: 2007-04-12 15:29:47|
|Subject: Re: Seeking Restoration Advice |