| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | susan(dot)hurst(at)brookhurstdata(dot)com |
| Cc: | Discuss List Postgres <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: copy command - something not found |
| Date: | 2020-12-29 19:55:40 |
| Message-ID: | 2193303.1609271740@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Susan Hurst <susan(dot)hurst(at)brookhurstdata(dot)com> writes:
> ##-- output from terminal window
> /home/dbzone/stp/rfc_db/RFC-00001/RFC-00001_copy_bar_active.csv:
> schema_name,table_name,table_alias: not found
> /home/dbzone/stp/rfc_db/RFC-00001/RFC-00001_copy_bar_active.csv:
> chief,source_systems,ssys: not found
> /home/dbzone/stp/rfc_db/RFC-00001/RFC-00001_copy_bar_active.csv:
> chief,lookup_categories,lcat: not found
> /home/dbzone/stp/rfc_db/RFC-00001/RFC-00001_copy_bar_active.csv:
> chief,lookup_data,ldat: not found
I'd say you're feeding the contents of the csv file to the Unix shell,
not to psql. It's not real clear how that would happen given what you
show as your initial shell command, but maybe ${CSVPATH} contains
something odd? Also, as David noted, "-c" without any argument
certainly isn't right.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Susan Hurst | 2020-12-29 19:58:59 | Re: copy command - something not found |
| Previous Message | Adrian Klaver | 2020-12-29 19:32:00 | Re: Dynamic procedure execution |