Horton

Re: Getting lengths of variable fields

Michelle Murrain <mpm@norwottuck.com>

View thread View on postgr.es
From: Michelle Murrain <mpm@norwottuck.com>
To: Tom Lane <tgl@sss.pgh.pa.us>, Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-general@postgresql.org
Date: 2001-03-06T00:24:30Z
Lists: pgsql-general 
On Monday 05 March 2001 05:55 pm, Tom Lane wrote:
>
> This info is stored in the 'atttypmod' field of pg_attribute, but I
> don't know whether DBD::Pg provides any handy interface to that.  You
> might have to get down-and-dirty enough to select it directly out of
> pg_attribute ...

Ah, I got it. Just do a select. It's a system table I hadn't learned about 
yet. And, I have to subtract 4 from it to get the real length. Thanks!!

Michelle
------------
Michelle Murrain, Ph.D.
President
Norwottuck Technology Resources
mpm@norwottuck.com
http://www.norwottuck.com