Postgres Pro
Downloads
Home   >   mailing lists

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

From Glyn Astill
Subject Using a variable as tablename ins plpgsql?
Date
Msg-id 600119.19604.qm@web23605.mail.ird.yahoo.com
Whole thread Raw
Responses Re: Using a variable as tablename ins plpgsql?  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: Using a variable as tablename ins plpgsql?  ("Fernando Moreno" <azazel.7@gmail.com>)
List pgsql-general
Tree view 
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?

Ta
Glyn







Send instant messages to your online friends http://uk.messenger.yahoo.com

pgsql-general by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: index scan leads to result that is different from sec scan after upgrading to 8.3.4
Next
From: "Pavel Stehule"
Date:
Subject: Re: Using a variable as tablename ins plpgsql?