Hi,
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
Roger
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
>
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/~checkout~/jxdbcon/src/org/sourceforge/jxdbcon/postgresql/PGDatabaseMetaData.java?rev=1.21&content-type=text/plain
> 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