Hi,

I want to automate a task to copy values to a table.

The shell script is this (simple form):
psql -U postgres -d sedait_db -c '
COPY dp_calc_temp
(
ano
)
FROM \'/usr/local/pgsql/home/dw/iva_dp/calculados/
dp_calculados_juntos.csv\' WITH CSV ; '

The problem is that I have to use ' to delimit the entire psql
command, but ' is also required to for the file reference.

I tried to escape ' with \', as in the example, but I get as a
response:
unexpected EOF while liiking for matching `''
syntax error: unexpected end of file

If I try no \ escaping, I get a syntax error near "/"

Also tried do use double ', but to no avail.

I even tried $/usr/...$, but didn't make it.

How can this be solved?


Luis

On 2007-09-05, luislupe (AT) gmail (DOT) com <luislupe (AT) gmail (DOT) com> wrote:

write your script in file and then psql .... -f file

rgds,
d.

On Sep 5, 3:56 pm, sircco <sir... (AT) online (DOT) hr> wrote:
Thank you! You saved my day, although this way there is some
flexibility lost, for example in assigning variable names to files.

Luis

luislupe (AT) gmail (DOT) com <luislupe (AT) gmail (DOT) com> wrote:
What keeps you from using double quotes?

psql ... -c "COPY .... FROM 'filename'"

Yours,
Laurenz Albe

luislupe (AT) gmail (DOT) com wrote:

You can only escape and use shell variables between double quotes, not
between single quotes. Best to use double quotes anyway,