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@xxxxxxxxxx> wrote:
From: Albe Laurenz <laurenz.albe@xxxxxxxxxx>
Subject: RE: libpq-how to add a schema to search path
To: "Divakar Singh *EXTERN*" <dpsmails@xxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxx
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
|
