Hi,
In my pl/pgsql procedure I have the following line:
execute 'copy cancella to ' || location || ' with
delimiter as \',\'';
Location is a string that gives the absolute pathname.
It's obvious what I'm aiming for, but this still gives
an error because of the two '' I'm missing around the
location var.
That's why I'm getting this error message:
NOTICE: location is hier
/usr/local/pgsql/data/plpgtrainin10.txt
ERROR: syntax error at or near "/" at character 18
QUERY: copy cancella to
/usr/local/pgsql/data/plpgtrainin10.txt with delimiter
as ','
CONTEXT: PL/pgSQL function "perform" line 16 at
execute statement
How can I solve it? I've tried a few things but keep
getting this error.
Thanks
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com