Re: Insertion of large xml files into PostgreSQL 10beta1

On Sun, Jun 25, 2017 at 8:02 PM, Alain Toussaint <atoussaint1976(at)gmail(dot)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.