Re: psql copy from through bash

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

Hi Kirk,
maybe try this:

cat $infile |

- Szymon