From: | Ken Johanson <pg-user(at)kensystem(dot)com> |
---|---|
To: | Kris Jurka <books(at)ejurka(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: Support for DatabaseMetadata: getCatalogName, getTableName, |
Date: | 2007-01-08 17:15:34 |
Message-ID: | 45A27C36.7060805@kensystem.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Kris Jurka wrote:
>
> What we get now in the V3 protocol:
>
> 1) the column name which may be an alias but we don't know if it came
> from an alias or not, consider SELECT a AS a. If we get "a" we don't
> know if it was aliased or not.
>
> 2) The underlying table's oid which can be used to lookup it's name and
> schema.
>
> 3) The underlying column's number in the table which can be used to
> lookup its name.
>
> No information on a table alias is available.
>
>> If so, does anyone know off hand if V3 is somehow extensible; i.e can
>> we add in metadata without breaking apps or major version?
>>
>
> No the RowDescription message is fixed:
>
> http://www.postgresql.org/docs/current/static/protocol-message-formats.html
>
Kris, do you know roughly when a v4 protocol could be on the radar?.. is
it months out (or years?), or has it even been discussed yet? I'm trying
to decide if I should vote-in on having this info added into that
version, if there is a discussion/planning thread somewhere...
Thx, ken
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Johanson | 2007-01-08 17:18:07 | Re: Synthesize support for Statement.getGeneratedKeys()? |
Previous Message | claudio ferraz | 2007-01-08 17:06:41 | How to recoup the messages on the execution of a query while the query is running , using java(JDBC)? |