how to do a SET search_path?

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: how to do a SET search_path?
Date: 2003-08-22 18:54:35
Message-ID: OFD8793501.E9E77BC4-ON88256D8A.00679858-88256D8A.00688412@fds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Garrick Dasbach 2003-08-22 19:40:20 Driver.acceptsURL(String) not working correctly
Previous Message Barry Lind 2003-08-22 17:29:36 Re: Stored Functions