Re: psql copy from through bash

[Kirk Wythers <wythe001@xxxxxxx>]

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?