Postgres Pro
Downloads
Home   >   mailing lists

how to do a SET search_path? - Mailing list pgsql-jdbc

From Patrick Hatcher
Subject how to do a SET search_path?
Date
Msg-id OFD8793501.E9E77BC4-ON88256D8A.00679858-88256D8A.00688412@fds.com
Whole thread Raw
Responses Re: how to do a SET search_path?
List pgsql-jdbc
Tree view 
I have two schemas (Public, MySchema) in my database, and I would like to
set the search_path to MySchema.  In the ODBC driver, I can set this at DSN
setup by entering
SET search_path TO MySchema.
how do I do this with the JDBC?

TIA

Patrick Hatcher

pgsql-jdbc by date:

Previous
From: Palle Girgensohn
Date:
Subject: Re: [BUGS] Bug #926: if old postgresql.jar in CLASSPATH,
Next
From: Curt Sampson
Date:
Subject: Re: how to do a SET search_path?