smallint to bigint - Mailing list pgsql-general

From Mickaël Jouanne
Subject smallint to bigint
Date
Msg-id 20001114122038.E23766@apr-job.com
Whole thread Raw
Responses Re: smallint to bigint  (Peter Eisentraut <peter_e@gmx.net>)
Re: smallint to bigint  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Hello !

I have a table with :

 prixandern | smallint     |
 prixcvdern | smallint     |

but i want to change smallint to bigint without droping the table.

How can i make that ?

thx for answers.

--

Mickaël JOUANNE
Webmaster / Developpeur / Support Technique

APR-Job & www.jobscout24.fr  - Meet your future
_______________________________________________

HumanLine France SAS     Tel: +33 1 42 44 40 73
32, rue Pierret          Fax: +33 1 49 26 09 76
92200 Neuilly            m.jouanne@humanline.fr

pgsql-general by date:

Previous
From: Marcos
Date:
Subject: about time.
Next
From: Florian Steffen
Date:
Subject: Time Interval Question