Selecting some schema not suported for libpq PQconnectdbParams

marcelo <marcelo.nicolet@gmail.com> writes:

The system I'm building needs to connect some QNX 4.x machines to the
Postgres' server (by the way, a Linux machine).

Of course, it will be done through a porting of the libpq library.

I was reading the possible parameters for the function mentioned in
the subject and none refers to the schema.
Also, the pg_service.conf file (to which may refer the "service"
parameter) don't add to the parameters enumerated in the section 31.1.

So... is there another way to tell the server which schema will be the
default schema for some database?

Of course, I'm asking this because the schema to use will not be the
"current user" nor "public".

.pg_service.conf...
[foo]
host=1.2.3.4
port=1234
dbname=groovydb
options=-c search_path=your_schema_of_choice,some_more_of_them_maybe

HTH

Any help will be appreciated.

TIA

Marcelo

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Thank you Jerry.
I read about "server parameters" as options, but forgotten search_path.

On 20/08/17 20:11, Jerry Sievers wrote:

marcelo <marcelo.nicolet@gmail.com> writes:

The system I'm building needs to connect some QNX 4.x machines to the
Postgres' server (by the way, a Linux machine).

Of course, it will be done through a porting of the libpq library.

I was reading the possible parameters for the function mentioned in
the subject and none refers to the schema.
Also, the pg_service.conf file (to which may refer the "service"
parameter) don't add to the parameters enumerated in the section 31.1.

So... is there another way to tell the server which schema will be the
default schema for some database?

Of course, I'm asking this because the schema to use will not be the
"current user" nor "public".

.pg_service.conf...
[foo]
host=1.2.3.4
port=1234
dbname=groovydb
options=-c search_path=your_schema_of_choice,some_more_of_them_maybe

HTH

Any help will be appreciated.

TIA

Marcelo

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general