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.
