Thread: modify table type1

modify table type1

From

Marco Giardini

Date:

13 February 2000, 21:55:36

 i have created 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 possible? how?

Thanks for replying to marco@tecnogi.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

Re: [GENERAL] modify table type1

From

Peter Eisentraut

Date:

15 February 2000, 10:05:03

On Mon, 14 Feb 2000, Marco Giardini wrote:

>  i have created 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 possible? how?

No, you have to recreate the table.


--
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden