Philip Couling <p...@pedal.me.uk> writes:
> I have a number of functions which I wish to wrap up in a SQL script
> (well technically DDL script). The functions reference one another and
> for safety it is necessary for them to ether set the search_path or
> directly reference the schema for one another.
> I was wondering if there is good / recommended way to write the install
> script to easily install to an arbitrary schema.
CREATE FUNCTION's "SET search_path FROM CURRENT" option might help you.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
