Re: [PERFORM] Related to Inserting into the database from XML file
I am little bit confused between whether to insert XML file as it is or insert data from the XML file in to a particular field from the table. I will decided it depending upon the performance factor For storing the XML file as it is, will there be any performance cause if compared to storing values in particular fields. If performance issue is not there for XML formats then we have around 12 to 13 tables, if we store XML data as it is in all tables then is there any generic format for select query? Thanks Soni On 8/27/06, George Pavlov <[EMAIL PROTECTED]> wrote: > On Fri, 2006-08-25 at 21:23 +0530, soni de wrote:> > Hello,> >> > I want to ask, Is there any way to insert records from XML > > file to the postgres database?>> Try the contrib/xml2 module.Alas, that module will not help you much with the insertion of records.It is more about querying XML that is stored within the database. A basic question is whether you want to store XML in the DB or you justhave data that is in XML now and you want it loaded into a tablestructure. The xml2 module will only be useful in the first case. In either case the approach is to transform the data into a form thatPGSQL's COPY understands or into a bunch of INSERT statements (much lessperformant). To that end you probably want to become familiar with XSLT unless the data is so simple that a processing with regular tools (perl,sed, awk) will suffice.George
Re: [PERFORM] Related to Inserting into the database from XML file
> On Fri, 2006-08-25 at 21:23 +0530, soni de wrote: > > Hello, > > > > I want to ask, Is there any way to insert records from XML > > file to the postgres database? > > Try the contrib/xml2 module. Alas, that module will not help you much with the insertion of records. It is more about querying XML that is stored within the database. A basic question is whether you want to store XML in the DB or you just have data that is in XML now and you want it loaded into a table structure. The xml2 module will only be useful in the first case. In either case the approach is to transform the data into a form that PGSQL's COPY understands or into a bunch of INSERT statements (much less performant). To that end you probably want to become familiar with XSLT unless the data is so simple that a processing with regular tools (perl, sed, awk) will suffice. George ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PERFORM] Related to Inserting into the database from XML file
On Fri, 2006-08-25 at 21:23 +0530, soni de wrote: > Hello, > > I want to ask, Is there any way to insert records from XML file to the > postgres database? Try the contrib/xml2 module. > > Please provide me some help regarding above query. > > Postgres version which we are using is 7.2.4 > I highly recommend upgrading if at all possible. That's quite an old version. Hope this helps, Jeff Davis ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[PERFORM] Related to Inserting into the database from XML file
Hello, I want to ask, Is there any way to insert records from XML file to the postgres database? Please provide me some help regarding above query. Postgres version which we are using is 7.2.4 Thanks, Sonal
