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]
