Re: how to do a SET search_path?

On Fri, 22 Aug 2003, Patrick Hatcher wrote:

> 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?

statement.executeUpdate("SET search_path TO MySchema");

(Note that the description in the JDSK 1.3 API docs says, "Executes an
SQL INSERT, UPDATE or DELETE statement. In addition, SQL statements that
return nothing, such as SQL DDL statements, can be executed.")

cjs
--
Curt Sampson <cjs(at)cynic(dot)net> +81 90 7737 2974 http://www.NetBSD.org
Don't you know, in this new Dark Age, we're all light. --XTC