Copy and xml files - Mailing list pgsql-general

From C G
Subject Copy and xml files
Date
Msg-id Law12-F102maiUYFjbh0001e1ee@hotmail.com
Whole thread Raw
Responses Re: Copy and xml files
List pgsql-general
Dear All,

I'm trying to insert an xml file into my database. I have a table with a
single text column. My intention is just to have the xml file take up one
row in the table.

I've tried the command

COPY t1 FROM '/tmp/file.xml';

but keep getting the error message

ERROR:  extra data after last expected column
CONTEXT:  COPY t1, line 32: "           <cn type="integer"> 1 </cn>"

Thanks for any help

Colin

_________________________________________________________________
Sign-up for a FREE BT Broadband connection today!
http://www.msn.co.uk/specials/btbroadband


pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: BLOB problem
Next
From: David Garamond
Date:
Subject: large crontab database design