Skip site navigation (1) Skip section navigation (2)

Re: Patch for Statement.getGeneratedKeys()

From: Kris Jurka <books(at)ejurka(dot)com>
To: Ken Johanson <pg-user(at)kensystem(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Patch for Statement.getGeneratedKeys()
Date: 2008-01-15 07:27:46
Message-ID: Pine.BSO.4.64.0801150222500.11728@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-jdbc

On Tue, 15 Jan 2008, Ken Johanson wrote:

> Ken Johanson wrote:
>> Do you know how we can get the current schema name? I presumed it might 
>> appear in SHOW ALL, but not so.
>> 
>
> Answer: select current_schema()  :-)
>

False, as I explained earlier there is no current schema.  Have 
a read of this:

http://www.postgresql.org/docs/8.2/static/ddl-schemas.html#DDL-SCHEMAS-PATH

You need to look through the schemas in the search_path in order and see 
which one a table with the given name appears in first.

Kris Jurka

In response to

Responses

pgsql-jdbc by date

Next:From: Hadraba PetrDate: 2008-01-15 08:41:43
Subject: Re: Batch Update problem
Previous:From: Ken JohansonDate: 2008-01-15 07:19:06
Subject: Re: Patch for Statement.getGeneratedKeys()

pgsql-general by date

Next:From: Tino WildenhainDate: 2008-01-15 08:47:45
Subject: Re: Query to get column-names in table via PG tables?
Previous:From: Ken JohansonDate: 2008-01-15 07:19:06
Subject: Re: Patch for Statement.getGeneratedKeys()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group