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 (wi

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 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 > >>> wrote: > Em 13/

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 wrote: Em 13/12/2012 20:10, Merlin Moncure escreveu: [...] *) diagram output should be standar

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 > > wrote: > >> Em 13/12/2012 20:10, Merlin Moncure escreveu: > >>[...] > > > *) diagram output should be standard html (only) without requir

Re: [GENERAL] XML Schema for PostgreSQL database

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

Re: [GENERAL] XML Schema for PostgreSQL database

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

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 wrote: Em 13/12/2012 20:10, Merlin Moncure escreveu: On Thu, Dec 13, 2012 at 1:54 PM, Edson Richter wrote: Has anyone created a XML Schema that would represent PostgreSQL database with all (or at le

Re: [GENERAL] XML Schema for PostgreSQL database

2012-12-14 Thread Merlin Moncure
On Thu, Dec 13, 2012 at 5:52 PM, Edson Richter wrote: > Em 13/12/2012 20:10, Merlin Moncure escreveu: > >> On Thu, Dec 13, 2012 at 1:54 PM, Edson Richter >> wrote: >>> >>> Has anyone created a XML Schema that would represent PostgreSQL database >>> with all (or at least, major) structures? >> >>

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 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 '

Re: [GENERAL] XML Schema for PostgreSQL database

2012-12-13 Thread Merlin Moncure
On Thu, Dec 13, 2012 at 1:54 PM, Edson Richter 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 -- Sent via pgsql-general

[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

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

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 X

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. -- Pe

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 docum

[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 notic