On Mon, Jan 12, 2009 at 9:12 AM, Ian Barwick <barw...@gmail.com> wrote: > 2009/1/12 Phoenix Kiula <phoenix.ki...@gmail.com>: >> I am trying to resize a column on a large-ish database (with 5 million rows). >> > > ALTER TABLE users ALTER COLUMN name TYPE VARCHAR(35) > > HTH >
Thanks! I guess I was missing the word "TYPE". This won't affect my "not null" on the column right? Also, is there a safe and fast way of doing this on a live database, without bringing it down if possible? This is an indexed column so I wonder if that will slow up the process quite a bit? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
