Postgres Pro
Downloads
Home   >   mailing lists

Thread: libpq-how to add a schema to search path

libpq-how to add a schema to search path

From
Divakar Singh
Date:
While making connection to PGSQL using libpq, is there any option to mention the schema name?
Something similar exists in java, however not sure about libpq.
http://stackoverflow.com/questions/4168689/is-it-possible-to-specify-schema-when-connecting-to-postgres-with-jdbc

Thanks in advance for help.

Re: libpq-how to add a schema to search path

From
"Albe Laurenz"
Date:
Divakar Singh wrote:
> While making connection to PGSQL using libpq, is there any option to
mention the schema name?
> Something similar exists in java, however not sure about libpq.

Use the "options" connection parameter, like this:

psql "dbname=test user=laurenz port=5432 options='-c
search_path=schema1,schema2'"

Yours,
Laurenz Albe

Re: libpq-how to add a schema to search path

From
Divakar Singh
Date:
Hi Laurenz,
Thanks for quick reply.
I hope it will help. Will check and revert.

Best Regards,
dpsmails


--- On Wed, 10/10/12, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:

From: Albe Laurenz <laurenz.albe@wien.gv.at>
Subject: RE: [GENERAL] libpq-how to add a schema to search path
To: "Divakar Singh *EXTERN*" <dpsmails@yahoo.com>, pgsql-general@postgresql.org
Date: Wednesday, October 10, 2012, 4:01 PM

Divakar Singh wrote:
> While making connection to PGSQL using libpq, is there any option to
mention the schema name?
> Something similar exists in java, however not sure about libpq.

Use the "options" connection parameter, like this:

psql "dbname=test user=laurenz port=5432 options='-c
search_path=schema1,schema2'"

Yours,
Laurenz Albe