Re: psql copy from through bash

Rob Sargentg <robjsargent@xxxxxxxxx> · Fri, 11 Jan 2013 19:37:43 -0700



    On 01/11/2013 11:32 AM, Kirk Wythers
      wrote:

    
        On Jan 11, 2013, at 12:18 PM, Szymon Guz <mabewlun@xxxxxxxxx>
          wrote:
        

              On 11 January 2013 19:13, Kirk
                Wythers <kwythers@xxxxxxx>
                wrote:

                Can
                  anyone see what I'm misisng? I am trying to run a psql
                  "copy from" command through a bash script to load a
                  buch of cdv files into the same table. I'm getting an
                  error about the file "infile" not existing?

                  
                  #!/bin/sh

                  
                  for infile in /path_to_files/*.csv

                  do

                     cat infile | psql dbname -c "\copy table_name FROM
                  stdin with delimiter as ',' NULL AS 'NA' CSV HEADER"

                  done

                  
                  Thanks in advance

                  
                      --

                      Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)

                      To make changes to your subscription:

                      http://www.postgresql.org/mailpref/pgsql-general

                    
            Hi Kirk,
            maybe try this:
            

              cat $infile |

            
      Oh my goodness! Thanks you. 
      

      Once more quickie. It seems that I am going to be asked for
        my password every time psql loops through the copy statement. 
      

      What is considered best practices to handle authentication? I
        am connecting locally, as myself as the user and I'm being asked
        for my user password. I added the -w (no-password) to the psql
        statement, but now assume I need to add a .pgpass file or
        something. 
      

      Suggestions?
      

    Yes a .pgpass file would work nicely