Re: Changing the column length - Mailing list pgsql-performance

From gnari
Subject Re: Changing the column length
Date
Msg-id 00ed01c49000$57ffd400$0100000a@wp2000
Whole thread Raw
In response to Changing the column length  ("Michael Ryan S. Puncia" <mpuncia@census.gov.ph>)
List pgsql-performance
From: "Michael Ryan S. Puncia" <mpuncia@census.gov.ph>

>             I am sorry that my question is out of line with this
> group(performance) but I need

-general might be more appropriate

>
> an urgent help :-( .pls .. I need to know how  to change the length of the
> column.

add a new column, use update to copy values from old column,
use alter table to rename columns

gnari



pgsql-performance by date:

Previous
From: "Stefano Bonnin"
Date:
Subject: Fw: Query performance issue with 8.0.0beta1
Next
From: "Stefano Bonnin"
Date:
Subject: Re: Query performance issue with 8.0.0beta1