how to change column type
От | Fernan Aguero |
---|---|
Тема | how to change column type |
Дата | |
Msg-id | 20001103150944.A15510@iib005.iib.unsam.edu.ar обсуждение исходный текст |
Список | pgsql-general |
Situation: I wanted to add a column to a table and after adding the column i realized that i would like to change the type of the column from varchar(n) to just char (1 character). The column does not hold any data yet (it is empty), so changing the type should not pose any problem. The problem is that I don't seem to find how to do it without dumping the table contents, recreating the table and getting the data into the table again. There seems to be no 'ALTER TABLE DROP column' or similar. Thanks in advance for your help. -- # --------------------------------------------------------- # # _ # # Fernan Aguero | / \ # # Bioinformatics | ASCII \ / against # # IIB-UNSAM | ribbon / HTML # # fernan@iib.unsam.edu.ar | campaign / \ email # # # # --------------------------------------------------------- #
В списке pgsql-general по дате отправления: