I think.. you'll need to parse that one... Where do you have your data types to xml document ?
2009/8/26 Erwin Brandstetter <brsaw...@gmail.com> > Hi! > > How do you import data from an xml-file? > For instance, if I have a file like this: > > <?xml version="1.0" encoding="utf-8"?> > <p_update> > <main_categories> > <main_category> > <main_category_name>Sonstiges</main_category_name> > <main_category_id>5</main_category_id> > </main_category> > <main_category> > <main_category_name>Buehne</main_category_name> > <main_category_id>2</main_category_id> > </main_category> > <main_category> > <main_category_name>Konzerte</main_category_name> > <main_category_id>1</main_category_id> > </main_category> > </main_categories> > <categories> > <category> > <category_name>Reggae</category_name> > <main_category_id>1</main_category_id> > <category_id>45</category_id> > </category> > <category> > <category_name>sonstige</category_name> > <main_category_id>5</main_category_id> > <category_id>44</category_id> > </category> > </categories> > </p_update> > > > ... and I want a CSV file like this: > > main_category_name main_category_id > Sonstiges 5 > Buehne 2 > > category_name main_category_id category_id > Reggae 1 45 > sonstige 5 44 > > > Or is there a way to import directly into tables in a postgres > database? > > > Your help would be appreciated! > Regards > Erwin > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
