Solved:-)
Thanks for your aanswer, now I can go further with
exploring pl/pgsql. Looks nice.
Brgds
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Dino Vliet <[EMAIL PROTECTED]> writes:
> > In my pl/pgsql procedure I have the following
> line:
>
> > execute 'copy cancella to ' || location || ' with
Dino Vliet <[EMAIL PROTECTED]> writes:
> In my pl/pgsql procedure I have the following line:
> execute 'copy cancella to ' || location || ' with
> delimiter as \',\'';
quote_literal(location) would work much better and more safely.
regards, tom lane
-
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
loca
