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
On 12/29/20 12:01 PM, Susan Hurst wrote:
Actually, the -c was in an example of a copy command that I found while
working at my last job. I tried executing the command without the -c and
got the same results as before, so I suppose I really don't know what it
means.
Can you enlighten me?
-c
> On Dec 29, 2020, at 11:12, Susan Hurst wrote:
>
> ##-- shell script command
> psql -d ${DBNAME} -U ${DBNAME} -h ${HOSTNAME} -c < ${CSVPATH}copycmd.z
The -c argument there specifies a command to run, so it needs an argument of
some kind. It looks like ultimately the .csv file gets handed
Hi
You could try to do "set +x" before running the script...
Thank you.
On Tue, Dec 29, 2020, 2:23 PM David G. Johnston
wrote:
> On Tue, Dec 29, 2020 at 1:01 PM Susan Hurst <
> susan.hu...@brookhurstdata.com> wrote:
>
>> Actually, the -c was in an example of a copy command that I found while
On Tue, Dec 29, 2020 at 1:01 PM Susan Hurst
wrote:
> Actually, the -c was in an example of a copy command that I found while
> working at my last job. I tried executing the command without the -c and
> got the same results as before, so I suppose I really don't know what it
> means.
>
> Can you
Actually, the -c was in an example of a copy command that I found while
working at my last job. I tried executing the command without the -c and
got the same results as before, so I suppose I really don't know what it
means.
Can you enlighten me?
---
Thank you for the reminders, John. I changed my .z file extension to
.tmp and removed the trailing / from my pre-defined directory path.
I'm still getting the same results as before though after changing the
.z file extension to .tmp.
The ${DBNAME} and ${HOSTNAME} variables are input at run
Susan Hurst writes:
> ##-- output from terminal window
> /home/dbzone/stp/rfc_db/RFC-1/RFC-1_copy_bar_active.csv:
> schema_name,table_name,table_alias: not found
> /home/dbzone/stp/rfc_db/RFC-1/RFC-1_copy_bar_active.csv:
> chief,source_systems,ssys: not found
>
On 12/29/20 9:29 AM, Mark Johnson wrote:
Don't you have to select into a variable and then return the variable to
the client per [1]?
Except PROCEDUREs do not return things(INOUT excepted), it would need to
be a FUNCTION.
Consider the following example from my Oracle system:
beginning
On Tuesday, December 29, 2020, Susan Hurst
wrote:
>
> ##-- shell script command
> psql -c < ${CSVPATH}copycmd.z
>
Given the meaning of “-c” what are you expecting that to do?
David J.
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"
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.
I've got one last complaint about the backend GSS code: we are doing
things randomly differently in the two places that install
krb_server_keyfile as the active KRB5_KTNAME value. secure_open_gssapi()
sets KRB5_KTNAME unconditionally (and doesn't bother to check for error,
either, not a good
Don't you have to select into a variable and then return the variable to
the client per [1]?
Consider the following example from my Oracle system:
beginning code ...
V_SQL := 'SELECT COUNT(*) FROM ' || V_TAB;
EXECUTE IMMEDIATE V_SQL INTO V_CNT;
ending code ...
[1]
On 12/28/20 10:34 PM, Muthukumar.GK wrote:
Pleas do not top post, the style on this list is bottom/inline posting.
Hi Adrian Klaver,
Sorry for typo mistake. Instead of writing lengthy query, I had written
it simple. Actually my main concept is to bring result set with multiple
rows (using
Svensson Peter writes:
> Yes, libpq patch solved our problem.
Thanks for confirming! I've pushed that patch and the server-side
fixes, so it'll be in February's releases.
regards, tom lane
Hi,
Yes, libpq patch solved our problem.
Before patch:
psql -h myserver -U myuser -d postgres
psql: error: FATAL: no pg_hba.conf entry for host "ip", user "myuser",
database "postgres", SSL off
FATAL: no pg_hba.conf entry for host "ip", user "myuser", database "postgres",
SSL off
With
17 matches
Mail list logo
