From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: dblink: give search_path |
Date: | 2018-04-11 14:26:32 |
Message-ID: | 2b63fb34-7057-d734-bdcc-284bd5c34e61@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 04/10/2018 11:44 PM, Thiemo Kellner wrote:
> 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.
In addition to my previous suggestions:
test=# SELECT public.dblink_connect('dbname=production ');
dblink_connect
----------------
OK
test=# select * from public.dblink('show search_path') as
t1(search_path text);
search_path
-------------
main
test=# select public.dblink_exec('set search_path=main,utility');
dblink_exec
-------------
SET
(1 row)
test=# select * from public.dblink('show search_path') as
t1(search_path text);
search_path
---------------
main, utility
>
> Function Schema: logger
> Database: act
> User: act
> User Default Schema: act
>
> Kind regards
>
> Thiemo
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2018-04-11 15:21:14 | Re: pg_basebackup restore a single table |
Previous Message | camarillo | 2018-04-11 13:53:00 | pg_basebackup restore a single table |