How can I change type of column

From: mlists <mlists(at)panforma(dot)co(dot)yu>
To: pgsql-general(at)postgresql(dot)org
Subject: How can I change type of column
Date: 2004-03-31 15:36:12
Message-ID: 406AE56C.8070606@panforma.co.yu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Dragan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nick Barr 2004-03-31 15:44:10 Re: select statement sorting
Previous Message Alexander Cohen 2004-03-31 15:31:43 select statement sorting