Postgres Pro
Downloads
Home   >   mailing lists

Re: question - plpgsql and query on table given by variable - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: question - plpgsql and query on table given by variable
Date
Msg-id 20050828215545.GA42193@winnie.fuhr.org
Whole thread Raw
In response to question - plpgsql and query on table given by variable  (" Jaromír Kamler" <kamler@centrum.cz>)
List pgsql-novice
Tree view 
On Sun, Aug 28, 2005 at 11:43:00PM +0200,  Jaromír Kamler wrote:
> I am new with PostgreSQL, I need create function in plpgsql where
> I use SQL question on the name of table whitch is given by variable
> in called function.

See "Executing Dynamic Commands" in the PL/pgSQL documentation.
Here's a link to the documentation for the latest version of
PostgreSQL (but use the documentation for whatever version you're
running):

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

--
Michael Fuhr

pgsql-novice by date:

Previous
From: " Jaromír Kamler"
Date:
Subject: question - plpgsql and query on table given by variable
Next
From: " Jaromír Kamler"
Date:
Subject: Fwd: Re: question - plpgsql and query on table given by variable