Thanks Michael and Steve. Related question: If I previously had a IF EXISTS (select ...) statement, and the 'select ...' part now needs to be run with EXECUTE, how do I check for existence? It looks like I need to do an 'INTO' with a row variable? I can't seem to find an example snippet of how to accomplish this in the pg docs. Where should I be looking? Thanks again! Gary On 6/23/07, Michael Glaesemann <grzm@xxxxxxxxxxxxxxx> wrote:
On Jun 23, 2007, at 22:47 , gary jefferson wrote: > Is there a way to use a variable as the name of a table or column > in plpgsql? AIUI, you need to use EXECUTE and build the query string yourself. http://www.postgresql.org/docs/8.2/interactive/plpgsql- statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN Take a look at the quote_ident function as well: http://www.postgresql.org/docs/8.2/interactive/functions-string.html Hope this helps you get started. Michael Glaesemann grzm seespotcode net
