Skip site navigation (1) Skip section navigation (2)

Re: Send parameters using Shell script to PostgreSQL

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: (view raw, whole thread or download thread mbox)
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
> and   file.cargar contain only the data who I whant put inside the BD whith
> the delimiter "|".
> $postgrelhome/bin/64/psql -w -h -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


I think your 


should be


ie. the single quoted value 'path/to/file' surrounded by double quotes.


Aarni Ruuhimäki
This is a bug-free broadcast from Ubuntu 9.10
Karmic Koala Linux System

PROUD TO BE 100% Microsoft FREE!

In response to


pgsql-novice by date

Next:From: wolfangDate: 2010-12-28 14:03:16
Subject: Re: Send parameters using Shell script to PostgreSQL
Previous:From: YAMAMOTO TakashiDate: 2010-12-28 05:08:05
Subject: batching commands with libpq

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group