Re: Trying to dynamically create a procedure

[Christophe Pettus]

> On Mar 26, 2025, at 13:27, Dirschel, Steve 
> <steve.dirsc...@thomsonreuters.com> wrote:
> 
>   I think the problem has to do with having AS $$ and END $$ with the 2 $’s.

PostgreSQL's multiline-string syntax is quite flexible.  You can do things like:

DO $doblock$
 ...
$doblock$
LANGUAGE plpgsql;

I tend to put the name of the function between the $s to avoid nesting problems.