Re: Alter column length - Mailing list pgsql-general

From Tom Lane
Subject Re: Alter column length
Date
Msg-id 18453.985367172@sss.pgh.pa.us
Whole thread Raw
In response to Alter column length  ("Dan Wilson" <phpPgAdmin@acucore.com>)
List pgsql-general
"Dan Wilson" <phpPgAdmin@acucore.com> writes:
> I want to alter the length of a column without dumping an re-creating the
> table.

What kind of column?

Offhand I think that hacking atttypmod would be safe for varchar(n)
but not char(n).  BTW, you might need to start a new backend session
to see the effects.

            regards, tom lane

pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: Re: Rules, views, sequences and returned values
Next
From: Bruce Momjian
Date:
Subject: Transcript of Internet Chat