Zitat von Adrian Klaver :
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
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 f
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 f
Zitat von Rene Romero Benavides :
What about setting the search path at the user level?
ALTER ROLE act SET search_path = act,logger;
Best.
Thanks for the inspiration. Maybe it is best to create a dedicated
user for logging anyway...
--
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/
What about setting the search path at the user level?
ALTER ROLE act SET search_path = act,logger;
Best.
2018-04-11 1:44 GMT-05:00 Thiemo Kellner :
> 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
