Re: Copy and xml files

Chris Gamache wrote:

>COPY works for whole tables, and can't append rows. ...
>
>
Wrong!

I use copy regularly to add data to a table.


...snip...

>--- C G <csgcsg39@hotmail.com> wrote:
>
>
>>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
>>
>>
If you are trying to import the whole file into one 'column' of a table, you will need to escape the "end of line"
[carriagereturn/line feed] characters. 

I believe this question has been asked many times, and the method of importing this type of data is in the archives.

Please check the archives.