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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
