On Tue, Jan 11, 2005 at 01:19:55PM -0800, Eric Brown wrote: > I know I can SET the schema search_path in a stored procedure, but is > there any way to retrieve it first so that I can get the current value > and manipulate that rather than just replace it?
See the current_setting() and set_config() functions in the "Functions and Operators" chapter of the documentation. In 7.3 and 7.4 they're in the "Miscellaneous Functions" section; in 8.0 they're in "System Administration Functions." -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
