Thread: [GENERAL] Selecting some schema not suported for libpq PQconnectdbParams
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". Any help will be appreciated. TIA Marcelo
Re: [GENERAL] Selecting some schema not suported for libpq PQconnectdbParams
From
Jerry Sievers
Date:
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
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