How can I change type of column - Mailing list pgsql-general

From mlists
Subject How can I change type of column
Date
Msg-id 406AE56C.8070606@panforma.co.yu
Whole thread Raw
Responses Re: How can I change type of column
Re: How can I change type of column
List 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




pgsql-general by date:

Previous
From: Alexander Cohen
Date:
Subject: select statement sorting
Next
From: Nick Barr
Date:
Subject: Re: select statement sorting