pasting a lot of commands to psql

From: Dmitry Shalashov <skaurus(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pasting a lot of commands to psql
Date: 2016-07-07 17:22:26
Message-ID: CAKPeCUEaqhwyVDBySp_twrNWZ8OfqD2=9nqu7g-jM0CeTfBuwg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everyone.

Let say that I have some sql file with like hundred of simple statements in
it. I `cat` it, copy it to buffer, go to my beloved psql and insert it
there.
But somewhere after first few lines it screws over:

b2b=> BEGIN;
b2b=> INSERT INTO oko_topsites VALUES('russian_federation','ati.su
',0,NULL,5);
INSERT INTO oko_topsites VALUES('russian_federation'b2b=> INSERT INTO
oko_topsites VALUES('russian_federation','atn.ua',0,NULL,5);
b2b=> INSERT INTO oko_topsites VALUES('russian_federation','audit-it.ru
',0,NULL,5);
b2b=> INSERT INTO oko_topsites VALUES('russian_federation','aup.ru
',0,NULL,5);
'
b2b=> INSERT INTO oko_topsites VALUES('russian_federation','autocentre.ua
',0,NULL,5);

b2b=> INSERT INTO oko_topsites VALUES('russian_federation','autodoc.ru
',0,NULL,5);

b2b=> INSERT INTO oko_topsites VALUES('russian_federation','calend.ru'

b2b(> INSERT INTO oko_topsites VALUES('russian_federation','calorizator.ru
',0,NULL,5)

Unclosed quotes, unclosed parenthesis - anyway it wont work.

How to safely insert big number of statements to psql at once?
I am aware about "execute this file" \i option of psql, that is not the
answer I am looking for, thanks :-)

Dmitry Shalashov, surfingbird.ru & relap.io

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sameer Kumar 2016-07-07 17:26:39 Re: pasting a lot of commands to psql
Previous Message Tom Lane 2016-07-07 17:01:35 Re: Fastest memmove in C