Re: Changing the column length

From: "gnari" <gnari(at)simnet(dot)is>
To: "Michael Ryan S(dot) Puncia" <mpuncia(at)census(dot)gov(dot)ph>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Changing the column length
Date: 2004-09-01 08:47:38
Message-ID: 00ed01c49000$57ffd400$0100000a@wp2000
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

From: "Michael Ryan S. Puncia" <mpuncia(at)census(dot)gov(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Stefano Bonnin 2004-09-01 09:18:52 Re: Query performance issue with 8.0.0beta1
Previous Message Markus Donath 2004-09-01 08:19:48 Re: odbc/ado problems