Getting lengths of variable fields

Michelle Murrain <mpm@norwottuck.com>

From: Michelle Murrain <mpm@norwottuck.com>
To: pgsql-general@postgresql.org
Date: 2001-03-05T21:44:54Z
Lists: pgsql-general
Hi folks,

I'm writing a very robust validation script in perl for database entry. One 
of the things I'd like to do is check how large a field is, and make sure 
that the entry into that field isn't too big. Problem is, for variable length 
fields, DBD::Pg returns a -1 size, using the pg_size attribute.

Is there something I am missing? Is there a way to get the size of variable 
length types using DBI/DBD::Pg, in particular, char() and varchar()?

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