Tom...I think you are right about feeding the contents of the csv file
to the shell instead of psql. After drilling down a bit more into my
script, I now think I have a UNIX shell script problem rather than a
psql problem.
I do appreciate everyone's input as it has been most helpful in my
efforts to figure out what is not the problem.
Thanks for your help!
Sue
---
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan.hurst@xxxxxxxxxxxxxxxxxx
Mobile: 314-486-3261
On 2020-12-29 13:55, Tom Lane wrote:
Susan Hurst <susan.hurst@xxxxxxxxxxxxxxxxxx> 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
