modify table type1

From: Marco Giardini <marco(at)tecnogi(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: modify table type1
Date: 2000-02-13 23:54:52
Message-ID: 20000214005452.A20578@tecnogi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i have create a table
+---------------+-------+---------+
| ref | int4 | 4 |
|family | text | var |
|typ | text | var |
+---------------+-------+---------+

Now i have the necessity to modify typ from text to int4.
Is it possibl? how?
Thanks for replying to marco(at)tecnogi(dot)com

marco
--
------------------------------------------------------------------
+-+-+-+-+-+ +-+-+-+-+-+-+-+-+
|m|a|r|c|o| |g|i|a|r|d|i|n|i|
+-+-+-+-+-+ +-+-+-+-+-+-+-+-+
TecnoGi spa Tel. +39 0321 885422
Strada per Gravellona Fax +39 0321 885333
Borgolavezzaro (NO) http://www.tecnogi.com
Key fingerprint = B5 B4 AA 91 89 50 43 8F B1 6B C6 8C 34 79 5A 7F

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Manuel Cabido 2000-02-14 01:28:48 Re: pgsql-general-digest V1 #638
Previous Message Marco Giardini 2000-02-13 23:48:45