Thread: XML Schema and PostgreSQL

XML Schema and PostgreSQL

From
Michael Weaver
Date:

Before I go off and right my own,
Does anyone know of any way to extract the DB schema as an XML file from PostgreSQL?

,

Mike Weaver
Software Developer

5, 42 Ladner Street
O'Connor, WA, 6163
All correspondence:
PO Box Y3502
East St Georges Terrace
Perth WA 6832

P: (+618) 9331 2700
F: (+618) 9331 3733
M: 0403 385 181
W: http://www.corpusglobe.com/
E: mweaver@corpusglobe.com

This email is intended only for the use of the individual or entity named above and may contain information that is confidential. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this email is strictly prohibited. When addressed to our clients, any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing Corpus Globe client engagement letter. If you have received this Email in error, please notify us immediately by return email or telephone +61 8 9331 2700 and destroy the original message. Thank You.

Re: XML Schema and PostgreSQL

From
Csaba Nagy
Date:
Michael,
 
You can check out this:
It is a JSP based web application, and it can read the schema from a Postgres DB and stores it as an XML in the web-inf directory.
The only problem is that it's the sources are not available, but it's not obfuscated either ;)
Actually the application is more targeted towards editing that schema... I'm sure the developer needs some testers and feedback.
 
Cheers,
Csaba.
 
PS: please use the latest JDBC driver from CVS, the older versions will not work - the application gets all foreign keys and that works awfully slow without a recently applied patch.
 
 
-----Ursprüngliche Nachricht-----
Von: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]Im Auftrag von Michael Weaver
Gesendet: Donnerstag, 16. Januar 2003 04:41
An: pgsql-general@postgresql.org
Betreff: [GENERAL] XML Schema and PostgreSQL

Before I go off and right my own,
Does anyone know of any way to extract the DB schema as an XML file from PostgreSQL?

,

Mike Weaver
Software Developer

5, 42 Ladner Street
O'Connor, WA, 6163
All correspondence:
PO Box Y3502
East St Georges Terrace
Perth WA 6832

P: (+618) 9331 2700
F: (+618) 9331 3733
M: 0403 385 181
W: http://www.corpusglobe.com/
E: mweaver@corpusglobe.com

This email is intended only for the use of the individual or entity named above and may contain information that is confidential. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this email is strictly prohibited. When addressed to our clients, any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing Corpus Globe client engagement letter. If you have received this Email in error, please notify us immediately by return email or telephone +61 8 9331 2700 and destroy the original message. Thank You.