Yes, it does. And it's a lot easier than DBMS_SQL too!
Look at the EXECUTE command in the pl/pgsql programming language.
See http://www.postgresql.org/docs/7.4/interactive/plpgsql-statements.html
John Sidney-Woollett
Mark Battersby wrote:
Hi
When looking at PostGres through the eyes of an Oracle Developer I was wondering if PostGres supports a feature called Dynamic SQL. Of course even better would be the ability to run PostGress/PL dynamically too.
Dynamic SQL and Dynamic PL/SQL are useful when you don't know until runtime how your SQL or PL/SQL looks like.
Any tips appreciated.
/Mark
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
