Re: [GENERAL] XML Schema for PostgreSQL database

2012-12-17 Thread Guillaume Lelarge
On Sun, 2012-12-16 at 22:25 -0200, Edson Richter wrote: Em 16/12/2012 20:27, Guillaume Lelarge escreveu: On Fri, 2012-12-14 at 14:17 -0200, Edson Richter wrote: Em 14/12/2012 12:21, Merlin Moncure escreveu: On Thu, Dec 13, 2012 at 5:52 PM, Edson Richter edsonrich...@hotmail.com wrote:

Re: [GENERAL] XML Schema for PostgreSQL database

2012-12-17 Thread Thomas Kellerer
Edson Richter wrote on 14.12.2012 00:52: I was wondering to create a tool for diagramming and database forward engineering. There are already few tools around. If you know a good diagramming tool able to database diff and forward engineering (with ALTER ..., not DROP and CREATE), I would

Re: [GENERAL] XML Schema for PostgreSQL database

2012-12-17 Thread Edson Richter
Em 17/12/2012 20:14, Thomas Kellerer escreveu: Edson Richter wrote on 14.12.2012 00:52: I was wondering to create a tool for diagramming and database forward engineering. There are already few tools around. If you know a good diagramming tool able to database diff and forward engineering

Re: [GENERAL] XML Schema for PostgreSQL database

2012-12-16 Thread Guillaume Lelarge
On Fri, 2012-12-14 at 14:17 -0200, Edson Richter wrote: Em 14/12/2012 12:21, Merlin Moncure escreveu: On Thu, Dec 13, 2012 at 5:52 PM, Edson Richter edsonrich...@hotmail.com wrote: Em 13/12/2012 20:10, Merlin Moncure escreveu: [...] *) diagram output should be standard html (only)

Re: [GENERAL] XML Schema for PostgreSQL database

2012-12-16 Thread Edson Richter
Em 16/12/2012 20:27, Guillaume Lelarge escreveu: On Fri, 2012-12-14 at 14:17 -0200, Edson Richter wrote: Em 14/12/2012 12:21, Merlin Moncure escreveu: On Thu, Dec 13, 2012 at 5:52 PM, Edson Richter edsonrich...@hotmail.com wrote: Em 13/12/2012 20:10, Merlin Moncure escreveu: [...] *) diagram

Re: [GENERAL] XML Schema for PostgreSQL database

2012-12-14 Thread Merlin Moncure
On Thu, Dec 13, 2012 at 5:52 PM, Edson Richter edsonrich...@hotmail.com wrote: Em 13/12/2012 20:10, Merlin Moncure escreveu: On Thu, Dec 13, 2012 at 1:54 PM, Edson Richter edsonrich...@hotmail.com wrote: Has anyone created a XML Schema that would represent PostgreSQL database with all (or

Re: [GENERAL] XML Schema for PostgreSQL database

2012-12-14 Thread Edson Richter
Em 14/12/2012 12:21, Merlin Moncure escreveu: On Thu, Dec 13, 2012 at 5:52 PM, Edson Richter edsonrich...@hotmail.com wrote: Em 13/12/2012 20:10, Merlin Moncure escreveu: On Thu, Dec 13, 2012 at 1:54 PM, Edson Richter edsonrich...@hotmail.com wrote: Has anyone created a XML Schema that would

Re: [GENERAL] XML Schema for PostgreSQL database

2012-12-14 Thread Atri Sharma
On Fri, Dec 14, 2012 at 9:47 PM, Edson Richter edsonrich...@hotmail.comwrote: Em 14/12/2012 12:21, Merlin Moncure escreveu: On Thu, Dec 13, 2012 at 5:52 PM, Edson Richter edsonrich...@hotmail.com wrote: Em 13/12/2012 20:10, Merlin Moncure escreveu: On Thu, Dec 13, 2012 at 1:54 PM, Edson

Re: [GENERAL] XML Schema for PostgreSQL database

2012-12-14 Thread Merlin Moncure
On Fri, Dec 14, 2012 at 10:17 AM, Edson Richter edsonrich...@hotmail.com wrote: Em 14/12/2012 12:21, Merlin Moncure escreveu: On Thu, Dec 13, 2012 at 5:52 PM, Edson Richter edsonrich...@hotmail.com wrote: Em 13/12/2012 20:10, Merlin Moncure escreveu: On Thu, Dec 13, 2012 at 1:54 PM, Edson

[GENERAL] XML Schema for PostgreSQL database

2012-12-13 Thread Edson Richter
Has anyone created a XML Schema that would represent PostgreSQL database with all (or at least, major) structures? Thanks, Edson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] XML Schema for PostgreSQL database

2012-12-13 Thread Merlin Moncure
On Thu, Dec 13, 2012 at 1:54 PM, Edson Richter edsonrich...@hotmail.com wrote: Has anyone created a XML Schema that would represent PostgreSQL database with all (or at least, major) structures? no -- furthermore, why would you want to? what would be the consumer of this 'schema'? merlin --

Re: [GENERAL] XML Schema for PostgreSQL database

2012-12-13 Thread Edson Richter
Em 13/12/2012 20:10, Merlin Moncure escreveu: On Thu, Dec 13, 2012 at 1:54 PM, Edson Richter edsonrich...@hotmail.com wrote: Has anyone created a XML Schema that would represent PostgreSQL database with all (or at least, major) structures? no -- furthermore, why would you want to? what would

Re: [GENERAL] XML schema

2007-11-16 Thread Sean Davis
On Nov 15, 2007 6:20 PM, Peter Eisentraut [EMAIL PROTECTED] wrote: Sean Davis wrote: Is the current XML datatype (in 8.3) the direction of the future, or is something more akin to a dedicated XML schema (I think this is the route that Oracle has gone) going to be important? An XML schema

Re: [GENERAL] XML schema

2007-11-16 Thread Peter Eisentraut
Sean Davis wrote: I meant a schema that represents a general mapping between XML and a relational schema.  In other words, I am looking for tools that use postgresql as the storage engine for a native XML database. There are ideas for that, but nothing to be expected any time soon. -- Peter

Re: [GENERAL] XML schema

2007-11-16 Thread Sean Davis
On Nov 16, 2007 2:14 PM, Peter Eisentraut [EMAIL PROTECTED] wrote: Sean Davis wrote: I meant a schema that represents a general mapping between XML and a relational schema. In other words, I am looking for tools that use postgresql as the storage engine for a native XML database. There

[GENERAL] XML schema

2007-11-15 Thread Sean Davis
Sorry for the cross-post, but I wasn't sure where this should go. I have a large XML file (about 7.5Gb) that is composed of about 17 million individual records. I have successfully loaded these records as individual XML records into a table with 17M rows. However, I looked around a bit and

Re: [GENERAL] XML schema

2007-11-15 Thread Peter Eisentraut
Sean Davis wrote: Is the current XML datatype (in 8.3) the direction of the future, or is something more akin to a dedicated XML schema (I think this is the route that Oracle has gone) going to be important? An XML schema is a specification that describes required properties of an XML