Re: Selecting some schema not suported for libpq PQconnectdbParams

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

In response to

Browse pgsql-general by date

  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