On Mon, Feb 7, 2011 at 1:01 AM, Richard Neill <postgre...@richardneill.org> wrote: > > The following bug has been logged online: > > Bug reference: 5867 > Logged by: Richard Neill > Email address: postgre...@richardneill.org > PostgreSQL version: 9.03 > Operating system: Linux > Description: wish: plpgsql print table for debug > Details: > > When debugging a plpgsql function, it would be really amazingly useful to be > able to do a regular psql-style SELECT, and have the result printed to > screen. > > Something like: > > Raise Notice table 'SELECT .... ' > > and then plpgsql would run the query and dump the result to screen, using > its helpful formatting. > > As far as I can see, this isn't possible (though there are a lot of people > searching for how to do it), and the only workaround is to manually handle > the looping and formatting, raising lots of individual notices. This makes > debugging much harder than it should be.
It wouldn't be too hard to write a loop that runs the select statement and does RAISE NOTICE on each row. Getting that into the psql formatting would be a little trickier, but I don't see why you couldn't write a PL/pgsql function to do it. Then you could just call that function and pass it an SQL query every time you want to do this. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
