Michael Glaesemann <grzm@xxxxxxxxxxxxxxx> writes: > On Dec 22, 2006, at 15:15 , Paul Silveira wrote: >> 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. Besides, you can get the effect already via PGOPTIONS: PGOPTIONS="--search_path=myschema,yourschema" psql ... regards, tom lane
