Altering Column Date Types - Mailing list pgsql-novice

From Desmond Coughlan
Subject Altering Column Date Types
Date
Msg-id 20030125031543.GB4834@lievre.voute.net
Whole thread Raw
List pgsql-novice
Hi,
I can't find anything in the docs about this.  I want to alter a column in
a table, which is currently an INTEGER, in order that it be FLOAT.

family=# \d debtors
            Table "debtors"
   Column    |     Type      | Modifiers
-------------+---------------+-----------
 first_name  | character(15) |
 second_name | character(15) |
 how_much    | integer       |
 city        | character(10) |
 country     | character(2)  |

Is this possible ?  All that I can see, are changing column names, changing
their defaults (if any), but not to change the data type.

Thanks.

D.

--
Desmond Coughlan          |'Io non mori, e non rimasi vivo'
desmond@zeouane.org
http://www.zeouane.org

Attachment

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Copy Questions
Next
From: Dmitri Touretsky
Date:
Subject: Very slow UPDATEs...