Обсуждение: JDBC compliance

Поиск
Список
Период
Сортировка

JDBC compliance

От
Daniel Stern
Дата:
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

От
Dave Cramer
Дата:
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
>
>