Re: Modifying search_path in a stored procedure

Eric Brown <eric(dot)brown(at)propel(dot)com> writes:
> 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?

current_setting() would produce the value you want to give back to SET
(or more likely set_config()). There's also current_schema() and
current_schemas() if you want a more digested form. See "System
Information Functions" and "System Administration Functions" in TFM.

It might also be that SET LOCAL would solve your problem with less fuss.

regards, tom lane