Re: PostgreSQL CHARACTER VARYING vs CHARACTER VARYING (Length)

[Rui DeSousa <rui@xxxxxxxxxxxxx>]

On Apr 28, 2020, at 8:34 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

Its less problematic now that increasing the generally arbitrary length doesn't require a table rewrite but you still need to rebuild dependent objects.

To increase a column length does not require a table rewrite or table scan; however, reducing its size will require a full table scan.  So cleaning up a schema like the one proposed sucks.