Thanks Scott!
(And thanks for all the other hints!)
Yes, the goal is to get the data into tables in a pg database. Having
a CSV file or having the data in pg-tables, both equally solve the
problem.
I like this approach as it does not involve additional tools. I will
have to upgrade to pg 8.4 firs
t; To: pgsql-general@postgresql.org
> Subject: [GENERAL] Import data from XML file
>
> Hi!
>
> How do you import data from an xml-file?
> For instance, if I have a file like this:
>
>
>
>
>
>Sonstiges
>
; Date: Wed, 26 Aug 2009 11:54:23 -0700
> From: arta...@comcast.net
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Import data from XML file
>
> > Hi!
> >
> > How do you import data from an xml-file?
> > For instance, if I have a file like this
2009 12:10
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Import data from XML file
>
> Hi!
>
> How do you import data from an xml-file?
> For instance, if I have a file like this:
>
>
>
>
>
>Sonstiges
>5
>
>
Hi!
How do you import data from an xml-file?
For instance, if I have a file like this:
Sonstiges
5
Buehne
2
Konzerte
1
Reggae
1
45
sonstige
5
44
... an
On Wed, Aug 26, 2009 at 09:10:25AM -0700, Erwin Brandstetter wrote:
> How do you import data from an xml-file?
If they're all that small, put the file into the database as is and then
use xpath[1] to pull it apart and turn it into something a database
understand.
--
Sam http://samason.me.uk/
I think.. you'll need to parse that one...
Where do you have your data types to xml document ?
2009/8/26 Erwin Brandstetter
> Hi!
>
> How do you import data from an xml-file?
> For instance, if I have a file like this:
>
>
>
>
>
> Sonstiges
> 5
>
>
> Buehne
Erwin Brandstetter wrote:
Hi!
How do you import data from an xml-file?
For instance, if I have a file like this:
Sonstiges
5
Buehne
2
Konzerte
1
Reggae
1
45
sonstige
Hi!
How do you import data from an xml-file?
For instance, if I have a file like this:
Sonstiges
5
Buehne
2
Konzerte
1
Reggae
1
45
sonstige
5
44
... and
