Hello Jan, Hello David, I'll be able to do further testing next week as I am in the middle of a move but for next week, I'll be in vacation from work for the whole month.
Best regards, Alain 2017-06-29 0:13 GMT-04:00 David G. Johnston <david.g.johns...@gmail.com>: > 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. > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
