From: | wolfang <wolfang83(at)hotmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Send parameters using Shell script to PostgreSQL |
Date: | 2010-12-27 19:41:48 |
Message-ID: | 1293478908547-3319655.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi....
I'm new using PostgreSQL, and I trying to run a script of shell where I can
send parameters to a sentence COPY but always returned an error.
This is my sentence in SHELL, where insertar_usuario_archivo.sql contain
this sentence SQL: \COPY T_SADCDMA_USUARIO_AAA from :v_archivo WITH
DELIMITER '|';
and file.cargar contain only the data who I whant put inside the BD whith
the delimiter "|".
$postgrelhome/bin/64/psql -w -h 192.168.85.50 -p 5432 -U aprn_des -f
/export/home/sso/LOADER_SADCDMA/insertar_usuario_archivo.sql -v
v_archivo='/export/home/sso/LOADER_SADCDMA/file.cargar' -d PGSQL_DES
This is the error that returned me when I run the sentence:
psql:/export/home/sso/LOADER_SADCDMA/insertar_usuario_archivo.sql:2:
:v_archivo: No such file or directory
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Send-parameters-using-Shell-script-to-PostgreSQL-tp3319655p3319655.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | YAMAMOTO Takashi | 2010-12-28 05:08:05 | batching commands with libpq |
Previous Message | Dave Page | 2010-12-27 19:10:19 | Re: COPY from PGAdmin |