Skip site navigation (1) Skip section navigation (2)

Re: Dynamic SQL

From: John Sidney-Woollett <johnsw(at)wardbrook(dot)com>
To: Mark Battersby <mark(dot)battersby(at)cvision(dot)cn>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dynamic SQL
Date: 2005-01-31 12:33:30
Message-ID: 41FE259A.3090406@wardbrook.com (view raw or flat)
Thread:
Lists: pgsql-general
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
> 
>  
> 
> 

In response to

  • Dynamic SQL at 2005-01-31 12:18:38 from Mark Battersby

pgsql-general by date

Next:From: Shridhar DaithankarDate: 2005-01-31 12:37:01
Subject: Re: Dynamic SQL
Previous:From: Rich DoughtyDate: 2005-01-31 12:26:09
Subject: Increasing the length of a varchar domain

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group