Table name as parameter

All,

I have a function that takes the table name the parameter. After some
digging I found that this can be made possible by have the query as a string
and EXECUTE it.

EXECUTE 'SELECT * FROM "' || table || '" WHERE <condition>';

The above works.

But I want the result in a record variable for further processing. So my
query actually is

EXECUTE 'SELECT * FROM "' || table || '" INTO "record_data" WHERE
<condition>';

This one will not work with the following error message:

ERROR:  syntax error at or near "INTO"


Can some one help me ?

Thanks,
Sairam Krishnamurthy
+1 612 859 8161