echo "INSERT INTO samples (xmldata) VALUES $(cat
/srv/pgsql/pubmed/medline17n0001.xml)" | /usr/bin/psql medline
1>/dev/null 2>error.log
Typically I do:
--psql file
\set xmlcontent `cat 'projectblogs-categories.xml'`
INSERT INTO tbl (col) VALUES (:'xmlcontent');
though at the moment I cannot recollect whether the above munges whitespace. I copied it from some json processing code where I wouldn't care if it did...
If you want to do something with INSERT/VALUES you should refresh yourself as to the syntax for the VALUES SQL Command. Namely non-optional parentheses.
I'd also suggest you try to get a one or two line file importing correctly first.
David J.
