From: | Niels Jespersen <NJN(at)dst(dot)dk> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | SV: SV: pg_service.conf and client support |
Date: | 2020-06-15 15:04:03 |
Message-ID: | ad229f2f1ac2493c9783b6df4f1a9aae@dst.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Fra: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Sendt: 15. juni 2020 15:36
Til: Niels Jespersen <NJN(at)dst(dot)dk>; pgsql-general(at)postgresql(dot)org
Emne: Re: SV: pg_service.conf and client support
On Mon, 2020-06-15 at 11:58 +0000, Niels Jespersen wrote:
> > For your examples that means:
> > - The PostgreSQL ODBC server can use pg_service.conf
> > - NpgSQL cannot use the file.
>
> You mention that the PostgreSQL ODBC driver can use pg_service.conf.
> But I cannot find any examples om how to construct a connectionstring that PostgreSQL ODBC will accept?
After looking at the code, I am no longer sure.
There doesn't seem to be a way to specify a general connection string.
You could try setting the environment variable PGSERVICE to specify the service.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
That is the way to do it. It works. Connectionstring
'Driver={PostgreSQL Unicode(x64)}'
And environment variables
PGSERVICEFILE and PGSERVICE
Will connect you. Thank you for helping with this.
Regards Niels
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Clarke | 2020-06-15 15:44:39 | Re: Assigning values to a range in Pgsql and inclusive / exclusive bounds |
Previous Message | Laurenz Albe | 2020-06-15 14:39:50 | Re: TOAST table size in bytes growing despite working autovacuum |