Re: getColumns() - workaround - Mailing list pgsql-jdbc

From Auri Mason
Subject Re: getColumns() - workaround
Date
Msg-id Pine.LNX.4.44.0204041602410.6845-100000@mendeleev.syntrex.com
Whole thread Raw
In response to Re: getColumns() - workaround  (Auri Mason <amason@syntrex.com>)
List 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


pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: Fwd: org/postgresql/jdbc2/ResultSet.java
Next
From: Dave Cramer
Date:
Subject: Re: getColumns() - workaround