Re: execute in pl/pgsql - Mailing list pgsql-general

From Tom Lane
Subject Re: execute in pl/pgsql
Date
Msg-id 6883.1157900100@sss.pgh.pa.us
Whole thread Raw
In response to execute in pl/pgsql  (Dino Vliet <dino_vliet@yahoo.com>)
Responses Re: execute in pl/pgsql  (Dino Vliet <dino_vliet@yahoo.com>)
List pgsql-general
Dino Vliet <dino_vliet@yahoo.com> 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

pgsql-general by date:

Previous
From: Dave Cramer
Date:
Subject: Re: [JDBC] Idle in transaction state.
Next
From: romantercero@gmail.com
Date:
Subject: Re: Database design and triggers...