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