Re: getColumns() - workaround

Auri,

Yes, if you go into psql and look at your tables you will find that they
are all lower case, regardless of how you created them.

Dave
On Thu, 2002-04-04 at 08:44, 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
>
>
>
> On 3 Apr 2002, Dave Cramer wrote:
>
> > Auri,
> >
> > AFAIK this works, can you give me specifics?
> >
> > ie db version, columns, code sample, etc.
> >
> > Dave
> > On Wed, 2002-04-03 at 11:22, Auri Mason wrote:
> > > Hi list,
> > >
> > > in my applications I use getColumns() method to retrieve the size of some
> > > fileds to avoid the exceed of the field size during an insert.
> > > This procedure works fine with oracle, DB2 and MSsql JDBC but seems it
> > > doesn't work (return a null) with the postgresql JDBC driver (feb 9 2002
> > > release).
> > > Anyone of you has some note/fix/workaround about this?
> > >
> > > p.s. I use % as schema
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>