On Sat, 01 Sep 2001 17:43:39 +0200, you wrote:
>I've tried the jxdbcon driver now and it gives another view
>of the actual database... I am not a PostgreSQL guy so I am
>quite confused here. Anyway, this one seems to give the most
>appropriate view of the database since the system tables
>are listed which the pgsql drivers did not list. 

Yes, I noticed that DatabaseMetaData.getColumns() in the
standard PostgreSQL driver returns the columns of the system
tables, whereas getTables() does not return those tables. I
guess that should be fixed. So documented on

>Could anyone point me to a place where I can download/get some 
>simple SQL statements to create at least relationsships between 
>two tables?

See the section "Reference constraint" on

René Pijlman <[EMAIL PROTECTED]>

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


Reply via email to