On Sun, Jun 25, 2017 at 8:02 PM, Alain Toussaint <atoussaint1...@gmail.com> wrote:
> > 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.
