Re: altering the datatype of a column.
От | Oliver Elphick |
---|---|
Тема | Re: altering the datatype of a column. |
Дата | |
Msg-id | 1091642544.31602.3090.camel@linda обсуждение исходный текст |
Ответ на | altering the datatype of a column. (Prabu Subroto <prabu_subroto@yahoo.com>) |
Список | pgsql-general |
On Wed, 2004-08-04 at 18:47, Prabu Subroto wrote: > Dear my friends... > > I want to change the datatype of a completed table > (has had already content). > But I don't know how. ... > Please tell me how. It is not possible in 7.4 Create a new column of the correct type; update the table to set the new column to have the data from the old one; delete the old column; rename the new one. -- Oliver Elphick olly@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== "And not only so, but we glory in tribulations also; knowing that tribulation worketh patience; And patience, experience; and experience, hope." Romans 5:3,4
В списке pgsql-general по дате отправления: