Quick Links

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

From:	Brian Minton <bminton(at)efn(dot)org>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Re: Changing the type of a column in an already populated database.
Date:	2002-11-22 04:45:35
Message-ID:	arkcpe$2g59$2@news.hub.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

In response to

Changing the type of a column in an already populated database. at 2002-11-21 09:58:24 from David Pradier

Responses

Re: Changing the type of a column in an already populated at 2002-11-22 08:57:05 from Tino Wildenhain
Re: Changing the type of a column in an already populated at 2002-11-22 16:06:50 from scott.marlowe
Re: Changing the type of a column in an already populated at 2002-11-23 18:46:59 from Medi Montaseri

Browse pgsql-general by date

	From	Date	Subject
Next Message	Egyud Csaba	2002-11-22 04:57:33	Re: Welcom & a problem
Previous Message	Brian Minton	2002-11-22 04:41:04	Re: Dumb Newbie Question - Mandrake 9.0 / PGSQL 7.2