Postgres Pro
Downloads
Home   >   mailing lists

Re: Using a variable as tablename ins plpgsql? - Mailing list pgsql-general

From Fernando Moreno
Subject Re: Using a variable as tablename ins plpgsql?
Date
Msg-id b1c45530810200954j79388182t5630f38f8e982282@mail.gmail.com
Whole thread Raw
In response to Using a variable as tablename ins plpgsql?  (Glyn Astill <glynastill@yahoo.co.uk>)
List pgsql-general
Tree view
2008/10/20 Glyn Astill <glynastill@yahoo.co.uk>
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.

pgsql-general by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: Using a variable as tablename ins plpgsql?
Next
From: Joshua Drake
Date:
Subject: Booth Volunteers for LISA 08 (San Diego)