Re: selecting table at execution with PL/PgSQL

Bill Nedell wrote:

> I am trying to write a PL/PgSQL function that can be given a table
> name as an argument at execution time and I don't see any way of doing
> it. I want the user to be able to specify the table dynamically when
> the function is run.
>
> As an example, if I try the following:
>
> CREATE OR REPLACE FUNCTION scrub() RETURNS VARCHAR AS '
> DECLARE
> tl pg_tables%ROWTYPE;
> BEGIN
> FOR tl IN SELECT * FROM pg_tables LOOP
> RAISE INFO ''table %'', tl.tablename;
> SELECT * FROM tl.tablename;

Try EXECUTE 'SELECT ....

where the execute parameter is created by assembling the select
statement string.

It's all in the documentation.

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