Sorry for this question is somewhat off the topic of this mailing list. I use the
DBVisualizer to run a sql script. I have
somethink like:
drop table a;
create table a(
. . .
);
drop table b;
create table b (
. . .
)
inherits a;
I get an error: Relation "b" inherits from "
Thanx for replying Dmitri,
I am aware of the JDBC API exposing information, it
might be an idea to use both the system tables and JDBC information in the this
case. The reason why i want to use the system tables is for example , (in MS SQL
Server and Oracle) the NVARCHAR and NVARCHAR2 datat
Kris,
I'm assuming you dont want to do this, but
just in case you're not aware of the option - the JDBC API exposes this
information.
hth
dim
- Original Message -
From:
Kris
To: [EMAIL PROTECTED]
Sent: Saturday, June 22, 2002 8:30
PM
Subject: [SQL] Obtaining p
Hi,
I am trying to generate some xml metadata from the
pg system tables for my java code generation utility. I have can get most
information, but i would like to be able to tell which column is a primary key
or which one is a foreign key (i dont need to know which table the foreign key
re
