| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tino Wildenhain | 2008-01-15 08:47:45 | Re: Query to get column-names in table via PG tables? |
| Previous Message | Ken Johanson | 2008-01-15 07:19:06 | Re: Patch for Statement.getGeneratedKeys() |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hadraba Petr | 2008-01-15 08:41:43 | Re: Batch Update problem |
| Previous Message | Ken Johanson | 2008-01-15 07:19:06 | Re: Patch for Statement.getGeneratedKeys() |