Re: psql "SCHEMA" switch

[Michael Glaesemann <grzm@xxxxxxxxxxxxxxx>]

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