Group: pgsql.novice


Subject: Using Execute with Dynamic Raise Commands
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 11/21/2007 11:43:44 AM
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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org