Re: Wrong column names in ResultSetMetaData

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Mike Martin <mmartin(at)vieo(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Wrong column names in ResultSetMetaData
Date: 2004-08-02 22:42:44
Message-ID: 410EC364.8090004@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Mike Martin wrote:

> The only way to "name" a SQL query column is with AS. There's
> corroboration in DatabaseMetaData:
>
> public boolean supportsColumnAliasing() throws SQLException
>
> Retrieves whether this database supports column aliasing.
> If so, the SQL AS clause can be used to provide names for
> computed columns or to provide alias names for columns as
> required.
>
> In both cases, "names" and not "labels".

Is an "alias name" the same as a "column name"?

-O

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mike Martin 2004-08-02 23:06:35 Re: Wrong column names in ResultSetMetaData
Previous Message Kris Jurka 2004-08-02 22:13:56 Re: Wrong column names in ResultSetMetaData