Philip Couling <phil@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
