On 1/29/2011 12:59 AM, Leon Starr wrote:
> I am deep into debugging some pretty extensive plpgsql and it would be nice sometimes if I could somehow output the content of a table to the psql console at a particular point in a function.
> For example, I am executing a select that is not returning the expected row. So I am wondering, what exactly was in the table at the time the query was performed.
> Of course, I could just write a loop prior to my query with a bunch of raise notice statements, but I'll get a stack trace for each one. So that won't be pretty.
> Suggestions? Thx.
Raise notice is PLPGSQL equivalent of DBMS_OUTPUT.PUT_LINE.
Sr. Oracle DBA
New York, NY 10036
In response to
pgsql-novice by date
|Next:||From: ashima athri||Date: 2011-01-30 03:55:42|
|Subject: Fwd: How to 'print a table' in the middle of a plpgsql function|
|Previous:||From: Leon Starr||Date: 2011-01-29 05:59:15|
|Subject: How to 'print a table' in the middle of a plpgsql function|