Re: getColumns() - workaround

From: Auri Mason <amason(at)syntrex(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: getColumns() - workaround
Date: 2002-04-04 14:04:16
Message-ID: Pine.LNX.4.44.0204041602410.6845-100000@mendeleev.syntrex.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

again me.. :)

works fine also with a view! ^_____^

On Thu, 4 Apr 2002, Auri Mason wrote:

> I've find the workaround for postreSQL
>
> //->>>>>>>>>>>>the following returns no rows!
> ResultSet rs = dma.getColumns(getCatalog(), getSchema(), tableName.toUpperCase(), fieldName.toUpperCase());
>
> //->>>> the following WORKS FINE!
> ResultSet rs = dma.getColumns("", "",tableName.toLowerCase(), fieldName.toLowerCase());
>
> BTW, it doesn't work if tablename is a view :(
>
> --
> Auri

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2002-04-04 14:23:17 Re: getColumns() - workaround
Previous Message Auri Mason 2002-04-04 13:44:07 Re: getColumns() - workaround