Postgres Pro
Downloads
Home   >   mailing lists

psql "SCHEMA" switch - Mailing list pgsql-general

From Paul Silveira
Subject psql "SCHEMA" switch
Date
Msg-id 8028863.post@talk.nabble.com
Whole thread Raw
Responses Re: psql "SCHEMA" switch  (Michael Glaesemann <grzm@seespotcode.net>)
Re: psql "SCHEMA" switch  ("Shoaib Mir" <shoaibmir@gmail.com>)
List pgsql-general
Tree view 
I was trying to run a psql script today against a database today.  This
script was schema agnostic.  (There were table creations and function
creations but none of them contained the specific schema to create them
in...)

I wanted to connect to a DB and then insert that new DDL into a "specific"
schema.  Because psql does not have a schema switch, I had to do it this
way...

sed -e '1i\\n SET search_path to contrib;\n' <
/usr/local/pgsql-8.2.0/share/contrib/tsearch2.sql | psql -dtemplate1 -p5433
-Upostgres

I would have liked to do it this way...
psql -dtemplate1 -p5433 -Upostgres -Xcontrib (I put an X there because "S"
was already taken.  It could be any letter...)

Anyone else agree?

-Paul



--
View this message in context: http://www.nabble.com/psql-%22SCHEMA%22-switch-tf2872570.html#a8028863
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: postgresql.org@tgice.com
Date:
Subject: Problem with index in OR'd expression
Next
From: Michael Glaesemann
Date:
Subject: Re: psql "SCHEMA" switch