Search Postgresql Archives

Re: dynamic table/col names in plpgsql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux