Re: [GENERAL] Import data from XML file

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

[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: ?xml version=1.0 encoding=utf-8? p_update main_categories main_category main_category_nameSonstiges/main_category_name main_category_id5/main_category_id /main_category

Re: [GENERAL] Import data from XML file

Erwin Brandstetter wrote: 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_nameSonstiges/main_category_name main_category_id5/main_category_id

Re: [GENERAL] Import data from XML file

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

Re: [GENERAL] Import data from XML file

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/

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: ?xml version=1.0 encoding=utf-8? p_update main_categories main_category main_category_nameSonstiges/main_category_name main_category_id5/main_category_id /main_category

Re: [GENERAL] Import data from XML file

-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: ?xml version=1.0 encoding=utf-8? p_update main_categories main_category main_category_nameSonstiges/main_category_name

Re: [GENERAL] Import data from XML file

-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: ?xml version=1.0 encoding=utf-8? p_update main_categories

Re: [GENERAL] Import data from XML file

] Import data from XML file 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_nameSonstiges/main_category_name main_category_id5