Postgres Pro
Downloads
Home   >   mailing lists

Re: PL/pgSQL: dynamic tablename - Mailing list pgsql-general

From Tom Lane
Subject Re: PL/pgSQL: dynamic tablename
Date
Msg-id 5548.1011562564@sss.pgh.pa.us
Whole thread Raw
In response to PL/pgSQL: dynamic tablename  (Jochem van Dieten <jochemd@oli.tudelft.nl>)
List pgsql-general
Tree view 
Jochem van Dieten <jochemd@oli.tudelft.nl> writes:
> Does anybody have any suggestion on how to use a dynamic tablename
> passed as an attribute in a function?

You need to use EXECUTE.  See past discussions.

            regards, tom lane

pgsql-general by date:

Previous
From: "Harald Massa"
Date:
Subject: row based security ... was Different views with same name for different users
Next
From: "Steve Boyle \(Roselink\)"
Date:
Subject: Re: PL/pgSQL: dynamic tablename