Check for proper number of command line args.

pg_col_resize.sh

#!/usr/bin/sh
if [ $# -ne 5 ]
then
    echo "Usage: "$0" DBUSER DB TABLE COL NEWSIZE"
else
    USER=$1
    DB=$2
    TABLE=$3
    COL=$4
    SIZE=$5
    echo "Resizing COL ["$COL"] in TABLE ["$DB"."$TABLE"] to "$SIZE
    psql $DB -U $USER <<SQL
    SELECT atttypmod as "CURRENT_SIZE" FROM pg_attribute WHERE attrelid = '$TABLE'::regclass AND attname = '$COL';
    UPDATE pg_attribute SET atttypmod = $SIZE+4 WHERE attrelid = '$TABLE'::regclass AND attname = '$COL';
    SELECT atttypmod as "NEWSIZE" FROM pg_attribute WHERE attrelid = '$TABLE'::regclass AND attname = '$COL';
SQL
fi

Sure. Makes us assume less...