Michael Glaesemann <grzm@seespotcode.net> 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