Re: how to do a SET search_path?

thank you

Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-422-1610 office
HatcherPT - AIM



                 
                    Curt Sampson
                 
                    <cjs@cynic.net       To:     Patrick Hatcher <PHatcher@macys.com>
                 
                    >                    cc:     pgsql-jdbc@postgresql.org
                 
                                         Subject:     Re: [JDBC] how to do a SET search_path?
                 
                    08/24/2003
                 
                    06:22 PM
                 

                 




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@cynic.net>   +81 90 7737 2974   http://www.NetBSD.org
    Don't you know, in this new Dark Age, we're all light.  --XTC