Re: dblink: give search_path

From: "Thiemo Kellner, NHC Barhufpflege" <thiemo(dot)kellner(at)gelassene-pferde(dot)biz>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: dblink: give search_path
Date: 2018-04-11 09:37:58
Message-ID: 20180411113758.197355wz0ezzxxoo@www.gelassene-pferde.biz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Zitat von Rene Romero Benavides <rene(dot)romero(dot)b(at)gmail(dot)com>:

> 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/lookup?op=get&search=0x8F70EFD2D972CBEF

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra Rao J S V 2018-04-11 10:00:10 Re: Planning to change autovacuum_vacuum_scale_factor value to zero. Please suggest me if any negative impact.
Previous Message Thiemo Kellner, NHC Barhufpflege 2018-04-11 09:36:28 Re: psql variable to plpgsql?