Re: psql "SCHEMA" switch - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: psql "SCHEMA" switch
Date
Msg-id 73998921-2665-4F19-B94D-08083B19EFD3@seespotcode.net
Whole thread Raw
In response to psql "SCHEMA" switch  (Paul Silveira <plabrh1@gmail.com>)
Responses Re: psql "SCHEMA" switch  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Dec 22, 2006, at 15:15 , Paul Silveira wrote:

> 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...

As the schema is part of the DDL, I think it's better to have it as
part of DDL script rather than a switch for psql, either as schema-
qualified tables in the script or using a SET search_path command in
the SQL script.

Michael Glaesemann
grzm seespotcode net



pgsql-general by date:

Previous
From: Paul Silveira
Date:
Subject: psql "SCHEMA" switch
Next
From: "Nikolay Samokhvalov"
Date:
Subject: Re: xml2 install problem