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
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
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
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 "
