On Thu, Jul 7, 2016 at 1:33 PM, Dmitry Shalashov <skaurus@xxxxxxxxx> wrote:
> \i your_file_nameI actually mentioned this way in my original posting. In my case it would involve copy-paste anyway - to create a file on a system where I have psql opened.I may do it that way. But why copy-paste directly to psql results in this behaviour?2016-07-07 20:30 GMT+03:00 Melvin Davidson <melvin6925@xxxxxxxxx>:This might seem a bit basic, but as long as you have a psql session, why not just use\i your_file_name>...I `cat` it, copy it to buffer, go to my beloved psql and insert it there.On Thu, Jul 7, 2016 at 1:26 PM, Sameer Kumar <sameer.kumar@xxxxxxxxxx> wrote:On Fri, 8 Jul 2016, 1:23 a.m. Dmitry Shalashov, <skaurus@xxxxxxxxx> wrote: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 :-)What are you exactly aiming to do?Have you tried -psql < myfile----Best RegardsSameer Kumar | DB Solution ArchitectASHNIK PTE. LTD.101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
This might seem a bit basic, but as long as you have a psql session, why not just use\i your_file_nameNo need to cat, copy & paste!--Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
It would help if you provided the version of PostgreSQL and the O/S.
Have you also tried simplifying the sql for multiple values in one statement?
eg:
INSERT INTO oko_topsites
VALUES
('russian_federation','ati.su',0,NULL,5),
('russian_federation','audit-it.ru',0,NULL,5),
...
...
('russian_federation','calorizator.ru',0,NULL,5);
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.