On Fri, 8 Jul 2016, 1:23 a.m. Dmitry Shalashov, <skau...@gmail.com> 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 > Dmitry Shalashov, surfingbird.ru & relap.io > -- -- Best Regards Sameer Kumar | DB Solution Architect *ASHNIK PTE. LTD.* 101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533 T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com