将XML文件导入PostgreSQL(Import XML files to PostgreSQL)

 我确实有很多XML文件，我想在表xml_data导入： 
 
create table xml_data(result xml);
 
 要做到这一点，我有一个简单的循环bash脚本： 
 
#!/bin/sh
FILES=/folder/with/xml/files/*.xml
for f in $FILES
do
  psql psql -d mydb -h myhost -U usr -c \'\copy xml_data from $f \'
done
 
 但是，这将尝试将每个文件的每一行作为单独的行导入。 这导致错误： 
 
ERROR:  invalid XML content
CONTEXT:  COPY address_results, line 1, column result: "<?xml version="1.0" encoding="UTF-8"?>"
 
 我明白为什么它失败了，但不知道如何使\copy将整个文件一次导入到单行中。 

I do have a lot of XML files I would like to import in the table xml_data:
 
create table xml_data(result xml);
 
To do this I have a simple bash script with loop:
 
#!/bin/sh
FILES=/folder/with/xml/files/*.xml
for f in $FILES
do
  psql psql -d mydb -h myhost -U usr -c \'\copy xml_data from $f \'
done
 
However this will try to import each line of every file as separate row. This leads to error:
 
ERROR:  invalid XML content
CONTEXT:  COPY address_results, line 1, column result: "<?xml version="1.0" encoding="UTF-8"?>"
 
I understand why it fails, but cannot figure out how to make \copy to import the whole file at once into single row.

原文：https://stackoverflow.com/questions/19007884