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