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. However, I do not
get anything back from any table when issuing the getExported/Imported
keys in DatabaseMetaData. This might be an effect of me not 
having any tables with primary-foreign key mappings. Could anyone
point me to a place where I can download/get some simple SQL 
statements to create at least relationsships between two tables?

I really would like to verify DbVisualizer with PostgreSQL since
more and more people requires support for it. 

Best regards


Keve Müller wrote:
> Hi all.
> > He's right. The DatabaseMetaData.getExportedKeys() method is
> > simply not yet implemented, both in the jdb1 and the jdbc2
> > driver. Its open for development.
> >
> > If someone can write the query on the system catalogs I'll be
> > glad to implement the Java code and a test case. The
> > documentation of the info we need is available on
> > http://java.sun.com/j2se/1.3/docs/api/java/sql/DatabaseMetaData.html
> > (look for getExportedKeys).
> An initial version for get(Imported|Exported)Keys and getCrossReference is
> available in jxDBCon (http://jxbdcon.sf.net) the file can be extracted
> automatically from CVS under
> Feel free to use it for a quick start.
> Initial means:
>         - not tested
>         - don't like its algorithm
>         -> needs to be improved
> But nevertheless it works.
> Regargs,
> Keve

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to