Re: Alter Column Wizard?

Hi Sven,

> -----Original Message-----
> From: Sven Köhler [mailto:skoehler(at)upb(dot)de]
> Sent: 16 June 2003 18:04
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Alter Column Wizard?
>
>
> Hi,
>
> i mailed to the postgresql-general list in order to clearify,
> why there
> is no full alter table/alter column command yet. One cannot
> change the
> column-type of a column with one command. You need to create a new
> column, copy data, delete the old one, recreate all
> constraints, indexes
> etc.
>
> This would be a beautiful feature for pgAdmin II/III.
>

We have looked at this problem a number of times in the past, and yes, it would be nice. Previously however, we had no dependency mechanism, or drop column available to us which made the task significantly harder.

I will have a think about how we might implement such a feature in pgAdmin III in the future.

Regards, Dave