Search Postgresql Archives

Re: Selecting some schema not suported for libpq PQconnectdbParams

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



marcelo <marcelo.nicolet@xxxxxxxxx> 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@xxxxxxxxxxx
p: 312.241.7800


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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux