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



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to