Skip site navigation (1) Skip section navigation (2)

Re: Setting schema from command line in psql

From: "Duncan Garland" <duncan(dot)garland(at)ntlworld(dot)com>
To: <psql-novice(at)netzach(dot)co(dot)il>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: Setting schema from command line in psql
Date: 2007-04-12 16:19:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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
command-line option.

It's just a thought ... I've never tried.

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of
Sent: 12 April 2007 14:57
To: pgsql-novice(at)postgresql(dot)org
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

  psql <dbname>

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-noviceDate: 2007-04-12 16:41:37
Subject: Re: Setting schema from command line in psql
Previous:From: Tom LaneDate: 2007-04-12 15:29:47
Subject: Re: Seeking Restoration Advice

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group