Can't really tell. You might want to post the output of the "printenv"
command to show us what the shell variables you are using have in them.
Oh, does ${CSVPATH} end in a slash? If it is something like "~/mycsvs" then
${CSVPATH}copycmd.z will expand to "~/mycsvscopycmd.z". Most "PATH"
environment variables don't end in a /, perhaps you need
"${CSVPATH}/copycmd.z" ? Also, as an aside. most UNIX files which end in .z
are compressed, IIRC. Make sure the contents of the file are plain text.
On Tue, Dec 29, 2020 at 1:12 PM Susan Hurst <susan.hu...@brookhurstdata.com>
wrote:
> I am trying to use the copy command from a csv files using a UNIX shell
> script but something is 'not found'...I can't figure out what is 'not
> found'. Below is my command from the shell script, the executed command,
> the content of the csv file and the output from trying to execute the
> command.
>
> Clearly, the file is being read but I can't figure out what is not
> found. BTW, the column names in the stg.bar_active table match the names
> and order in the first row of the csv file. What should I be looking
> for?
>
> Thanks for your help!
>
> Sue
>
> ##-- shell script command
> psql -d ${DBNAME} -U ${DBNAME} -h ${HOSTNAME} -c < ${CSVPATH}copycmd.z
>
> ##-- executed command
> "copy stg.bar_active from
> '/home/dbzone/stp/rfc_db/RFC-00001/RFC-00001_copy_bar_active.csv'
> delimiter ',' CSV HEADER;"
>
> ##-- content of .csv file
> schema_name,table_name,table_alias ...(this is the header
> row)
> chief,source_systems,ssys
> chief,lookup_categories,lcat
> chief,lookup_data,ldat
>
> ##-- 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
>
> ##-- select version();
> PostgreSQL 11.9 on amd64-portbld-freebsd12.1, compiled by FreeBSD clang
> version 8.0.1 (tags/RELEASE_801/final 366581) (based on LLVM 8.0.1),
> 64-bit
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Susan E Hurst
> Principal Consultant
> Brookhurst Data LLC
> Email: susan.hu...@brookhurstdata.com
> Mobile: 314-486-3261
>
>
>
