Changing the type of a column in an already populated database.

From: David Pradier <dpradier(at)apartia(dot)fr>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Changing the type of a column in an already populated database.
Date: 2002-11-21 09:58:24
Message-ID: 20021121095824.GA26551@apartia.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I'd like to know if it is possible to change the type of a column to a
compatible one, in an already populated database.
For example, changing a column from varchar(20) to varchar(25) ?
I'm using postgresql 7.3rc1

Thanks for your help.

Best regards,
David
--
dpradier(at)apartia(dot)fr

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henry Pedask 2002-11-21 10:05:11 PostgreSQL compilation with custom table name length
Previous Message Erwan DUROSELLE 2002-11-21 09:40:40 Rp. : double quotes around table and column names