Re: Dynamic SQL

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
>
>
>
>