pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRelated to Inserting into the database from XML file
4+ messages / 3 participants
[nested] [flat]
* Related to Inserting into the database from XML file
@ 2006-08-25 15:53 soni de <soni.de@gmail.com>
2006-08-25 16:19 ` Re: Related to Inserting into the database from XML file Jeff Davis <pgsql@j-davis.com>
0 siblings, 1 reply; 4+ messages in thread
From: soni de @ 2006-08-25 15:53 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Related to Inserting into the database from XML file
2006-08-25 15:53 Related to Inserting into the database from XML file soni de <soni.de@gmail.com>
@ 2006-08-25 16:19 ` Jeff Davis <pgsql@j-davis.com>
2006-08-27 14:18 ` Re: Related to Inserting into the database from XML file George Pavlov <gpavlov@mynewplace.com>
0 siblings, 1 reply; 4+ messages in thread
From: Jeff Davis @ 2006-08-25 16:19 UTC (permalink / raw)
To: soni de <soni.de@gmail.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Related to Inserting into the database from XML file
2006-08-25 15:53 Related to Inserting into the database from XML file soni de <soni.de@gmail.com>
2006-08-25 16:19 ` Re: Related to Inserting into the database from XML file Jeff Davis <pgsql@j-davis.com>
@ 2006-08-27 14:18 ` George Pavlov <gpavlov@mynewplace.com>
2006-08-28 05:31 ` Re: Related to Inserting into the database from XML file soni de <soni.de@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: George Pavlov @ 2006-08-27 14:18 UTC (permalink / raw)
To: Jeff Davis <pgsql@j-davis.com>; soni de <soni.de@gmail.com>; +Cc: pgsql-performance
> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Related to Inserting into the database from XML file
2006-08-25 15:53 Related to Inserting into the database from XML file soni de <soni.de@gmail.com>
2006-08-25 16:19 ` Re: Related to Inserting into the database from XML file Jeff Davis <pgsql@j-davis.com>
2006-08-27 14:18 ` Re: Related to Inserting into the database from XML file George Pavlov <gpavlov@mynewplace.com>
@ 2006-08-28 05:31 ` soni de <soni.de@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: soni de @ 2006-08-28 05:31 UTC (permalink / raw)
To: George Pavlov <gpavlov@mynewplace.com>; +Cc: Jeff Davis <pgsql@j-davis.com>; pgsql-performance
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 <gpavlov@mynewplace.com> 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 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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-08-28 05:31 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-25 15:53 Related to Inserting into the database from XML file soni de <soni.de@gmail.com>
2006-08-25 16:19 ` Jeff Davis <pgsql@j-davis.com>
2006-08-27 14:18 ` George Pavlov <gpavlov@mynewplace.com>
2006-08-28 05:31 ` soni de <soni.de@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox