From: | marcelo <marcelo(dot)nicolet(at)gmail(dot)com> |
---|---|
To: | Jerry Sievers <gsievers19(at)comcast(dot)net> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Selecting some schema not suported for libpq PQconnectdbParams |
Date: | 2017-08-21 13:54:23 |
Message-ID: | 6e0a0463-0735-0a22-83e4-55ee76027908@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)nicolet(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | marcelo | 2017-08-21 16:27:56 | Porting libpq to QNX 4.25 |
Previous Message | Abhijit Gharami | 2017-08-21 10:26:57 | PostgreSQL 9.4.13 is facing issue in shutting down |