Re: Alter column length

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dan Wilson" <phpPgAdmin(at)acucore(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Alter column length
Date: 2001-03-23 17:06:12
Message-ID: 18453.985367172@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Dan Wilson" <phpPgAdmin(at)acucore(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-03-23 17:12:02 Re: Slow SELECT...IN statements
Previous Message will trillich 2001-03-23 16:55:27 Re: internationalizing text