Re: int4 to varchar length (pgadmin3) issue - Mailing list pgsql-novice

> iow, i want to limit the the newly converted varchar
> revision to 2 characters, but can't due to the grayed
> out boxes in pgadmin3.

I saw this example at:
http://www.postgresql.org/docs/8.1/interactive/sql-altertable.html

ALTER TABLE distributors ADD CONSTRAINT zipchk CHECK (char_length(zipcode) = 5);

This should do what you want.

Regards,

Richard Broersma Jr.