Re: psql copy from through bash

On 01/11/2013 11:32 AM, Kirk Wythers wrote:
>
> On Jan 11, 2013, at 12:18 PM, Szymon Guz <mabewlun(at)gmail(dot)com
> <mailto:mabewlun(at)gmail(dot)com>> wrote:
>
>>
>>
>>
>> On 11 January 2013 19:13, Kirk Wythers <kwythers(at)umn(dot)edu
>> <mailto:kwythers(at)umn(dot)edu>> 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(at)postgresql(dot)org
>> <mailto:pgsql-general(at)postgresql(dot)org>)
>> 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