从动态表名称中选择

像这样的东西…(参见 RETURN QUERY EXECUTE in the plpgsql portion of the manual )

CREATE function dynamic_table_select(v_id int) returns setof text as $$
DECLARE 
    v_table_name text;
BEGIN
    SELECT app_label || '_' || model into 
    v_table_name from django_content_type where id = v_id;
    RETURN QUERY EXECUTE 'SELECT a_text_column from '||quote_ident(v_table_name);
    RETURN;
END
$$ LANGUAGE plpgsql;

http://www.postgresql.org/docs/8.1/static/ecpg-dynamic.html

我认为最基本的答案是 EXECUTE IMMEDIATE