On Wed, Aug 16, 2006 at 12:43:07PM +0800, aBBISh wrote: > i want use a variable to denote a table name in select query. See "Executing Dynamic Commands" in the PL/pgSQL documentation: http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN -- Michael Fuhr