Re: Smartest way to resize a column?

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "Ian Barwick" <barwick(at)gmail(dot)com>, "Adrian Klaver" <aklaver(at)comcast(dot)net>
Cc: "PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Smartest way to resize a column?
Date: 2009-01-12 01:21:46
Message-ID: e373d31e0901111721n22b11518h96384b44c0426d98@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jan 12, 2009 at 9:12 AM, Ian Barwick <barwick(at)gmail(dot)com> wrote:
> 2009/1/12 Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2009-01-12 01:43:42 Re: Smartest way to resize a column?
Previous Message Adrian Klaver 2009-01-12 01:14:40 Re: Smartest way to resize a column?