Re: search_path in SQL script? - Mailing list pgsql-novice

From Tom Lane
Subject Re: search_path in SQL script?
Date
Msg-id 1494.1050291367@sss.pgh.pa.us
Whole thread Raw
In response to search_path in SQL script?  (Jeffrey Melloy <jmelloy@visualdistortion.org>)
Responses Triggers  (Ben Clewett <B.Clewett@roadrunner.uk.com>)
List pgsql-novice
Jeffrey Melloy <jmelloy@visualdistortion.org> writes:
> I'm working on a simple SQL script, and I'd like a method of appending
> my newly created schema to the existing search_path.

You could read current_schemas() and build a new value to set
search_path to.  But I fear that a plain noninteractive script file
may not have an easy way to do that ...

            regards, tom lane


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Numeric user ID invalid in 7.3 ?
Next
From: Paul Makepeace
Date:
Subject: Automated restore?