In your SQL script file you can add at the start something like this:
set search_path = contrib
and that should take care of it without this change in psql.
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/23/06, Paul Silveira <[EMAIL PROTECTED]> wrote:
I was trying
Michael Glaesemann <[EMAIL PROTECTED]> 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, ei
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 scr
I was trying to run a psql script today against a database today. This
script was schema agnostic. (There were table creations and function
creations but none of them contained the specific schema to create them
in...)
I wanted to connect to a DB and then insert that new DDL into a "specific"
s
