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.a...@wien.gv.at> wrote: From: Albe Laurenz <laurenz.a...@wien.gv.at> Subject: RE: [GENERAL] libpq-how to add a schema to search path To: "Divakar Singh *EXTERN*" <dpsma...@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
