On 11 January 2013 19:13, Kirk Wythers <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) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
Hi Kirk, maybe try this: cat $infile | - Szymon
