Copy and xml files - Mailing 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