How to 'print a table' in the middle of a plpgsql function

Поиск
Список
Период
Сортировка
От Leon Starr
Тема How to 'print a table' in the middle of a plpgsql function
Дата
Msg-id 6149D332-A822-4F8C-A04E-1D98BF0DD916@modelint.com
обсуждение исходный текст
Ответы Re: How to 'print a table' in the middle of a plpgsql function  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
Список 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 по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: Set default time zone for displaying dates in a session
Следующее
От: Mladen Gogala
Дата:
Сообщение: Re: How to 'print a table' in the middle of a plpgsql function