Rene,

I've attached some sample code, the script I use for creating the database, 
and the output when I run it here:

   
I am sorry, but I didn't notice the Null Pointer Exception being produced 
by the getIndexInfo method.  It doesn't seem to matter whether I supply a 
table name, schema name or catalog name, I always get the exception.

Thanks for the info on where to get the souurce code and the JDBC 
compliance URL.  I'll follow these up when I get time.

Regards,

Tom
[EMAIL PROTECTED]

-----Original Message-----
From:   Rene Pijlman [SMTP:[EMAIL PROTECTED]]
Sent:   07 September 2001 09:13
To:     Tom Falconer
Cc:     '[EMAIL PROTECTED]'
Subject:        Re: [JDBC] DatabaseMetadata problems

On Thu, 6 Sep 2001 22:30:58 +0100, you wrote:
>The problems are:
>1. No Index information from the getIndexInfo method

Hmmm... looking at the source, it apppears that
DatabaseMetaData.getIndexInfo() is implemented. If it doesn't
work for you, we would need more information about the problem
to be able to fix it.

>2. Indexes included as tables in getTables

Again, can you provide us with more detailed information about
the problem? A small test case would be nice, which creates a
few tables and indexes and shows incorrect output.

>3. Only one column in the entire database is returned in getColumns

getColumns() was fixed recently. It returned only columns with a
comment (IIRC). This should be fixed in release 7.2.

>4. The catalog name is not returned in getTables

The PostgreSQL driver intentionally ignores the catalog
parameter of the metadata methods, and it returns null for the
catalog in the metadata it returns.

I don't know if this could be implemented and how. Also, any
interpretation of this concept we come up with has to be
consistent with the backend's understanding of the SQL
standard's concept 'catalog'.

Reading the book "Understanding the SQL standard" it seems that
what the standard calls a schema is a database in PostgreSQL. A
catalog is a set of schemas. Following the standard, a session
is supposed to have access to a catalog, but in PostgreSQL it
has access to a database.

Perhaps this feature has not yet been implemented because of
such fundamental mapping problems.

>5. Comment columns contain 'No Comment' instead of null

That was fixed recently in getTables(), getColumns() and
getProcedures(). The fix wil appear in release 7.2.

>Where are the sources, as I am willing to take a look at them to
>try at least identify the problems in more detail

http://developer.postgresql.org/

I would also like to point you to our JDBC compliance effort:
http://lab.applinet.nl/postgresql-jdbc/. However, the
DatabaseMetaData section is still very much under construction.

I'll be glad to document any deviations of the standard you may
find (please post new issues on this list). Since this is a
volunteer open source project, we cannot guarantee if and when
the problems will be fixed.

Regards,
Rene Pijlman <[EMAIL PROTECTED]>

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl
Tables:

Dumping ResultSet:
        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: cust_invs
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: cust_name_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: customers_pkey
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
invoice_lines_pkey
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: invoices_pkey
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: parts_pkey
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_aggregate_name_type_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_am_name_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_amop_opid_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_amop_strategy_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_attrdef_adrelid_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_attribute_relid_attnam_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_attribute_relid_attnum_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_class_oid_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_class_relname_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_description_objoid_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_group_name_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_group_sysid_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_index_indexrelid_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_index_indrelid_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: char     Value: 
null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_operator_oid_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_operator_oprname_l_r_k_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_proc_oid_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_proc_proname_narg_type_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_relcheck_rcrelid_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_rewrite_oid_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_rewrite_rulename_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_statistic_relid_att_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_toast_1215_idx
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_toast_1216_idx
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_toast_1255_idx
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_toast_16600_idx
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_toast_17058_idx
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_toast_17086_idx
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_trigger_tgconstrname_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_trigger_tgconstrrelid_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_trigger_tgrelid_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_type_oid_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: 
pg_type_typname_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: INDEX
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: customers
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: invoice_lines
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: invoices
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: parts
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_aggregate
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_am
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_amop
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_amproc
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_attrdef
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_attribute
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_class
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_database
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_description
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_group
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_index
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_inheritproc
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_inherits
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_ipl
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_language
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_largeobject
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_listener
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_opclass
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_operator
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_proc
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_relcheck
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_rewrite
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_shadow
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_statistic
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_trigger
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

        Column 1        Name: TABLE_CAT Type: varchar   Value: null
        Column 2        Name: TABLE_SCHEM       Type: varchar   Value: null
        Column 3        Name: TABLE_NAME        Type: varchar   Value: pg_type
        Column 4        Name: TABLE_TYPE        Type: varchar   Value: TABLE
        Column 5        Name: REMARKS   Type: varchar   Value: no remarks

---------

End of ResultSet

Indexes:
java.lang.NullPointerException
        at org.postgresql.jdbc2.ResultSet.getBytes(ResultSet.java, Compiled Code)
        at 
org.postgresql.jdbc2.DatabaseMetaData.getIndexInfo(DatabaseMetaData.java:2716)
        at postgrestest.TestBed.printTest(TestBed.java:50)
        at postgrestest.TestBed.main(TestBed.java:117)
Closing

psql_schema.sql

TestBed.java


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to