How to 'print a table' in the middle of a plpgsql function - Mailing list pgsql-novice

From Leon Starr
Subject How to 'print a table' in the middle of a plpgsql function
Date
Msg-id 6149D332-A822-4F8C-A04E-1D98BF0DD916@modelint.com
Whole thread Raw
Responses Re: How to 'print a table' in the middle of a plpgsql function  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
List pgsql-novice
I am deep into debugging some pretty extensive plpgsql and it would be nice sometimes if I could somehow output the
contentof 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
thetable 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
tracefor each one.  So that won't be pretty. 

Suggestions?  Thx.

- Leon

pgsql-novice by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Set default time zone for displaying dates in a session
Next
From: Mladen Gogala
Date:
Subject: Re: How to 'print a table' in the middle of a plpgsql function