Re: Using a variable as tablename ins plpgsql?

["Fernando Moreno" <azazel.7@xxxxxxxxx>]

2008/10/20 Glyn Astill <glynastill@xxxxxxxxxxx>

Hi people,

Hopefully this is a quickie, I want to pass in a table name to a plpgsql function and then use that table name in my queries.

Is EXECUTE the only way to do this?

 

As far as I know, yes. That's the only way to create queries using dynamic table and column names.