On Mar 7, 2011, at 8:02 PM, Durumdara wrote: > Hi! > > In other RDBMS I found a way to make dynamic statements. > I can use variables, or concat the SQL segments, and execute it all. > > :tablename = call CreateTempTable; > insert into :tablename .... > drop table :tablename > > or (FireBird like cursor handling): > > sql = "select * from " || :tablename || " where..." > for select :sql .... > ... > > Can I do same thing in PGSQL too? > > Thanks: > dd
You can use EXECUTE dynamic Command of plgpsql: http://www.postgresql.org/docs/8.4/static/plpgsql-statements.html Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company vibhor.ku...@enterprisedb.com Blog:http://vibhork.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
