Thread: JDBC compliance

JDBC compliance

From
Daniel Stern
Date:
Hello

I'm using the current release of PostgreSQL 7.2.1 on Mac OS X 10.1.5.
I'd like to know
how I can get the metadata from a tables columns ( getColumns( catalog,
scheme, table,column ) ).

I tried getColumns( null, null, tableName, null ); because there is no
scheme-concept
within postgresql. Also I tried getColumns( catalog, null, tableName,
null ), but nothing
helps.

What's the problem. Is the current driver able to get all the required
meta data from
the database???

Thanks for help

Daniel Stern


Re: JDBC compliance

From
Dave Cramer
Date:
Daniel

Try getColumns("" "" tablename, "%" );

Dave
On Mon, 2002-06-10 at 05:08, Daniel Stern wrote:
> Hello
>
> I'm using the current release of PostgreSQL 7.2.1 on Mac OS X 10.1.5.
> I'd like to know
> how I can get the metadata from a tables columns ( getColumns( catalog,
> scheme, table,column ) ).
>
> I tried getColumns( null, null, tableName, null ); because there is no
> scheme-concept
> within postgresql. Also I tried getColumns( catalog, null, tableName,
> null ), but nothing
> helps.
>
> What's the problem. Is the current driver able to get all the required
> meta data from
> the database???
>
> Thanks for help
>
> Daniel Stern
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>