Re: search_path in SQL script?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: search_path in SQL script?
Дата
Msg-id 1494.1050291367@sss.pgh.pa.us
обсуждение исходный текст
Ответ на search_path in SQL script?  (Jeffrey Melloy <jmelloy@visualdistortion.org>)
Ответы Triggers
Список pgsql-novice
Jeffrey Melloy <jmelloy@visualdistortion.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


В списке pgsql-novice по дате отправления: