Re: [GENERAL] Insertion of large xml files into PostgreSQL 10beta1

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] Insertion of large xml files into PostgreSQL 10beta1
Дата
Msg-id CAKFQuwY6egNyZAn+_gtHukhHZpze6GuAgEKp+fc639jQxZmRtA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Insertion of large xml files into PostgreSQL 10beta1  (Alain Toussaint <atoussaint1976@gmail.com>)
Ответы Re: [GENERAL] Insertion of large xml files into PostgreSQL 10beta1
Список pgsql-general
Дерево обсуждения
On Sun, Jun 25, 2017 at 8:02 PM, Alain Toussaint <atoussaint1976@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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Jan de Visser
Дата:
Сообщение: Re: [GENERAL] Insertion of large xml files into PostgreSQL 10beta1
Следующее
От: Alain Toussaint
Дата:
Сообщение: Re: [GENERAL] Insertion of large xml files into PostgreSQL 10beta1