On 2004.03.31 09:36 mlists wrote:
Can I change type of column with alter table command?
For instance if I have a table t1 and column c1 which is defined as decimal(18, 2) and I want to change it into decimal(18, 3) in MS SQL server I can write:
alter table t1 alter column c1 decimal(18, 3)
Is there something similar in PostgreSQL? Tnx in advance.
Not that I know of. You either have to add a new column, copy the data with UPDATE, drop the old column, and then alter the new column to disallow NULL if necessary or you have to do a pg_dump on the table and drop and re-create the table. The latter if you've scripts or whatever relying on the 'order' of the columns as returned with SELECT * type statements.
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
