Re: pasting a lot of commands to psql

Rob Sargent <robjsargent@xxxxxxxxx> · Thu, 7 Jul 2016 11:58:36 -0600



    If, on the wild chance you're an emacs user, if the section is in a
    ".sql" buffer Ctrl-C Ctrl-B will send the entire buffer.  Not sure
    if there's a practical limit on the number of line/statements, but
    I've used this with a couple of "pages" worth of sql.

    
    On 07/07/2016 11:48 AM, Dmitry
      Shalashov wrote:

    
      Oh sweet! Thanks!
      

                      Dmitry Shalashov, surfingbird.ru & relap.io

                    
        2016-07-07 20:39 GMT+03:00 Scott Mead <scottm@xxxxxxxxxxx>:

          
                On Thu, Jul 7,
                    2016 at 1:30 PM, Dmitry Shalashov <skaurus@xxxxxxxxx>
                    wrote:

                    
                      Hi Sameer,
                        

                        I am trying to copy-paste (and execute)
                          random snippets of SQL to psql console.
                        

                        There is another ways to do it, which do
                          not involve copy-paste, but I am wondering why
                          is copy-paste won't work. What exactly is
                          happening there...
                      
                      
                                        Dmitry Shalashov, surfingbird.ru & relap.io

                                      
                            2016-07-07 20:26
                              GMT+03:00 Sameer Kumar <sameer.kumar@xxxxxxxxxx>:

                              
                                    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 :-)
                                        
                                      
                  My personal favorite for this exact thing is to
                    use '\e'
                  

                    When you are in psql, if you \e (on *nix) it
                    will open a temp file in whatever your $EDITOR
                    variable is set ( I use vim).  Paste your data, then
                    save-close the file.  It will put you back into psql
                    and execute the command for you.
                  

                  --Scott
                  
                     
                                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
                                        
                                      
                    -- 

                    
                                      --

                                        Scott Mead

                                        Sr. Architect

                                        OpenSCG
                                      http://openscg.com