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