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: pgsql-general@postgresql.org
Cc: pgsql-general@postgresql.org
Date: 2001-03-05T23:04:20Z
Lists: pgsql-general 
On Monday 05 March 2001 05:55 pm, Tom Lane wrote:

> What Michelle seems to want is the declared limit on field width, not
> the actual width of any particular value.

Yes, that's exactly what I want.

> 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 ...

I couldn't seem to find it - and I'm going to show my naivete here - how do I 
get hold of it if there is no interface in DBD::Pg?

THanks!!

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