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