Thread: Dynamic SQL

Dynamic SQL

From
"Craig Bryden"
Date:
Hi

I am trying to get information on how to do "Dynamic SQL" in PostgreSQL
(preferably pg/plsql).
Please can someone give an exaple of how this is done or direct me to the
relevant documentation.

Thanks
Craig


Re: Dynamic SQL

From
Sean Davis
Date:
On Jun 16, 2005, at 6:21 AM, Craig Bryden wrote:

> Hi
>
> I am trying to get information on how to do "Dynamic SQL" in PostgreSQL
> (preferably pg/plsql).
> Please can someone give an exaple of how this is done or direct me to
> the
> relevant documentation.

There is searchable documentation here (bookmark it--it is quite
good....):

http://www.postgresql.org/docs/8.0/static/index.html

And the relevant section is here:

http://www.postgresql.org/docs/8.0/static/plpgsql-
statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN


Sean