Re: search_path in SQL script?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: search_path in SQL script?
Date: 2003-04-14 03:36:07
Message-ID: 1494.1050291367@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Jeffrey Melloy <jmelloy(at)visualdistortion(dot)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

In response to

Responses

  • Triggers at 2003-04-14 16:33:21 from Ben Clewett

Browse pgsql-novice by date

  From Date Subject
Next Message Paul Makepeace 2003-04-14 14:22:46 Automated restore?
Previous Message Danny Aldham 2003-04-14 00:06:16 What version am I running?