From: | Susan Hurst <susan(dot)hurst(at)brookhurstdata(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: copy command - something not found |
Date: | 2020-12-29 20:53:09 |
Message-ID: | 8a390a7b2e845d38e0a2413966cb5b93@mail.brookhurstdata.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)hurst(at)brookhurstdata(dot)com
Mobile: 314-486-3261
On 2020-12-29 13:55, Tom Lane wrote:
> 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 | Stephen Frost | 2020-12-30 15:00:40 | Re: Problem with ssl and psql in Postgresql 13 |
Previous Message | Adrian Klaver | 2020-12-29 20:43:39 | Re: copy command - something not found |