Postgres Pro
Downloads
Home   >   mailing lists

Re: Changing the type of a column in an already populated database. - Mailing list pgsql-general

From Brian Minton
Subject Re: Changing the type of a column in an already populated database.
Date
Msg-id arkcpe$2g59$2@news.hub.org
Whole thread Raw
In response to Changing the type of a column in an already populated database.  (David Pradier <dpradier@apartia.fr>)
Responses Re: Changing the type of a column in an already populated
Re: Changing the type of a column in an already populated
List pgsql-general
Tree view 
David Pradier wrote:
> 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

dump the database, edit the dump file, and reload.  of course, this is
annonying on live data, but it works

pgsql-general by date:

Previous
From: Brian Minton
Date:
Subject: Re: Dumb Newbie Question - Mandrake 9.0 / PGSQL 7.2
Next
From: Savita
Date:
Subject: Question about DEADLOCK