Setting schema from command line in psql
От | psql-novice@netzach.co.il |
---|---|
Тема | Setting schema from command line in psql |
Дата | |
Msg-id | Pine.LNX.4.58.0704121654280.32231@localhost обсуждение исходный текст |
Ответы |
Re: Setting schema from command line in psql
|
Список | pgsql-novice |
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 ? Thanks, Daniel
В списке pgsql-novice по дате отправления: