Alter column length - Mailing list pgsql-general

From Dan Wilson
Subject Alter column length
Date
Msg-id 000f01c0b3b6$513c25d0$543987cf@corp.peoplesoft.com
Whole thread Raw
Responses Re: Alter column length  (Tom Lane <tgl@sss.pgh.pa.us>)
RE: Alter column length  ("Tamsin" <tg_mail@bryncadfan.co.uk>)
List pgsql-general
I want to alter the length of a column without dumping an re-creating the
table.

I found this method in the archives and was just wondering if there are any
side effects...

-----------------------------
update pg_attribute set atttypmod = [column_oid] where attname =
'[column_name]' where attrelid = (select oid from pg_class where relname =
'[table_name]');
-----------------------------

Will doing this cause any problems?

-Dan



pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Lost Trigger(s)?
Next
From: "Mihai Gheorghiu"
Date:
Subject: Migration from MSAccess