fieldwidths

postgresql'rs-

i've looked through to docs a bit, but have not found a way to quickly
calculate the maximum fieldwidth of each field in a tuple set. i'd like to be
able to do something like :

select field_widths(*) from relation;

where 'field_width' means the width as printed out by the default to_char()
method.

obviously psql does something internally to do it's formatting, but whatever
it does is very fast... any ideas?

-a

--
====================================
| Ara Howard
| NOAA Forecast Systems Laboratory
| Information and Technology Services
| Data Systems Group
| R/FST 325 Broadway
| Boulder, CO 80305-3328
| Email: ahoward(at)fsl(dot)noaa(dot)gov
| Phone: 303-497-7238
| Fax: 303-497-7259
====================================