Horton
Menu

Re: Alter Table Column Datatype

Rod Taylor <rbt@rbt.ca>

View thread
From: Rod Taylor <rbt@rbt.ca>
To: Christof Petig <christof@petig-baender.de>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2003-09-29T15:02:47Z
Lists: pgsql-hackers 
     A. On Mon, 2003-09-29 at 10:28, Christof Petig wrote:
> Rod Taylor schrieb:
> >         Is this syntax ok?
> >                 ALTER TABLE <table> ALTER COLUMN <column> TYPE <new
> >                 type>
> 
> shouldn't that be
>    ALTER TABLE <table> ALTER [COLUMN] <column> [TYPE] <new type>
> which I clearly remember from different database systems.

I should be able to do that.

Thanks.