Re: Dynamic SQL

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: "Craig Bryden" <postgresql(at)bryden(dot)co(dot)za>
Cc: "pgsql" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dynamic SQL
Date: 2005-06-16 11:07:27
Message-ID: d013544fa43a26f4a6b327c57e894b11@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message sathish 2005-06-16 11:07:29 Experiencing problems with stored procedures
Previous Message Andrew Dunstan 2005-06-16 10:55:40 Re: Autovacuum in the backend