Dynamic SQL

Started by Craig Brydenalmost 21 years ago2 messagesgeneral
Jump to latest
#1Craig Bryden
postgresql@bryden.co.za

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

#2Sean Davis
sdavis2@mail.nih.gov
In reply to: Craig Bryden (#1)
Re: Dynamic SQL

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