pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: gnari <gnari@simnet.is>
To: Michael Ryan S. Puncia <mpuncia@census.gov.ph>
To: pgsql-performance@postgresql.org
Subject: Re: Changing the column length
Date: Wed, 1 Sep 2004 08:47:38 -0000
Message-ID: <00ed01c49000$57ffd400$0100000a@wp2000> (raw)
References: <200409010641.i816fDkJ025384@mail.census.gov.ph>

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





view thread (3+ messages)  latest in thread

Message-ID: <00ed01c49000$57ffd400$0100000a@wp2000>
Permalink:  ../00ed01c49000$57ffd400$0100000a@wp2000/
Also on:    postgresql.org/message-id/00ed01c49000$57ffd400$0100000a@wp2000

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gnari@simnet.is, mpuncia@census.gov.ph
  Subject: Re: Changing the column length
  In-Reply-To: <00ed01c49000$57ffd400$0100000a@wp2000>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox