From: | Aarni <aarni(at)kymi(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Cc: | wolfang <wolfang83(at)hotmail(dot)com> |
Subject: | Re: Send parameters using Shell script to PostgreSQL |
Date: | 2010-12-28 13:51:35 |
Message-ID: | 201012281551.35367.aarni@kymi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Monday 27 December 2010 21:41:48 wolfang wrote:
> 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
>
Hi,
I think your
v_archivo='/export/home/sso/LOADER_SADCDMA/file.cargar'
should be
v_archivo="'/export/home/sso/LOADER_SADCDMA/file.cargar'"
ie. the single quoted value 'path/to/file' surrounded by double quotes.
BR,
Aarni
--
Aarni Ruuhimäki
--------------
This is a bug-free broadcast from Ubuntu 9.10
Karmic Koala Linux System
PROUD TO BE 100% Microsoft FREE!
From | Date | Subject | |
---|---|---|---|
Next Message | wolfang | 2010-12-28 14:03:16 | Re: Send parameters using Shell script to PostgreSQL |
Previous Message | YAMAMOTO Takashi | 2010-12-28 05:08:05 | batching commands with libpq |