Re: How to alter the size of a column

From: Chris Bitmead <chrisb(at)nimrod(dot)itg(dot)telstra(dot)com(dot)au>
To: Michael Talbot-Wilson <mtw(at)birdseye(dot)view(dot)net(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to alter the size of a column
Date: 2000-08-01 04:21:31
Message-ID: 3986504B.94A4B03B@nimrod.itg.telecom.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Talbot-Wilson wrote:
>
> > I want to alter the size of a column, say from char(40) to char(80),
> > but it seem that
> > the ALTER does not support such operation, nor does it support column
> > removing.
> >
> > How can I do for this ?
>
> I would also like to know how to do both of these things.

I'm not aware of an easy way of doing it. But you can dump your schema
and data separately. Manually edit your schema. Reload the schema then
reload the data.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2000-08-01 04:26:06 Re: pg_dump & performance degradation
Previous Message Don Baccus 2000-08-01 04:15:10 Re: pg_dump & performance degradation