Re: Using Execute with Dynamic Raise Commands - Mailing list pgsql-novice

From Tom Lane
Subject Re: Using Execute with Dynamic Raise Commands
Date
Msg-id 11916.1195663424@sss.pgh.pa.us
Whole thread Raw
In response to Using Execute with Dynamic Raise Commands  (Robert Bernabe <rbernabe@sandmansystems.com>)
List pgsql-novice
Robert Bernabe <rbernabe@sandmansystems.com> writes:
>    I've been trying to create a debugging function that would receive a
> tablename and a list of columns and then the function would display all
> the contents of the table using the RAISE command.

There's no such thing as a "dynamic raise command" --- EXECUTE is for
executing regular SQL statements, not plpgsql things.  You hardly need
anything dynamic in your example anyway, seeing that you've built up
the string you want to display just fine.

            regards, tom lane

pgsql-novice by date:

Previous
From: Robert Bernabe
Date:
Subject: Using Execute with Dynamic Raise Commands
Next
From: Pavel SRB
Date:
Subject: sql file in the tutorial directory