dblink: give search_path

Поиск
Список
Период
Сортировка
От Thiemo Kellner
Тема dblink: give search_path
Дата
Msg-id 20180411084417.11492xo2gdx9zni8@www.gelassene-pferde.biz
обсуждение исходный текст
Ответы Re: dblink: give search_path  (Rene Romero Benavides <rene.romero.b@gmail.com>)
Re: dblink: give search_path  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: dblink: give search_path  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения 
Hi all

I try to execute a function not in the Schema I connect to with
dblink. Is there way to tell dblink to set search_path in a specific
way? I have not found a solution in the documentation. I tried with
the set search_path definition in the function declarations to no avail.

Function Schema: logger
Database: act
User: act
User Default Schema: act

Kind regards

Thiemo

--
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0x8F70EFD2D972CBEF

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: difference between checkpoint_segments and wal_keep_segments inpostgres configuration file
Следующее
От: Thiemo Kellner
Дата:
Сообщение: psql variable to plpgsql?