Resize varchar column

From: "John Sidney-Woollett" <johnsw(at)wardbrook(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Resize varchar column
Date: 2004-02-04 14:45:37
Message-ID: 2590.192.168.0.64.1075905937.squirrel@mercury.wardbrook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible to alter a table to resize a varchar column? The PG docs
indicate lots of uses for "alter table T alter column C..." but not one
that allows the changing of the type (or same type, new size).

This is possible in Oracle (provided you are increasing the column size).

Is there a way to resize the column without having to drop or recreate the
table or column?

Thanks

John Sidney-Woollett

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2004-02-04 15:08:59 Re: Resize varchar column
Previous Message Christopher Browne 2004-02-04 14:33:02 Re: pg_generate_sequence and info_schema patch (Was: SELECT