smallint to bigint

From: Mickaël Jouanne <m(dot)jouanne(at)apr-job(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: smallint to bigint
Date: 2000-11-14 11:20:38
Message-ID: 20001114122038.E23766@apr-job.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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(dot)jouanne(at)humanline(dot)fr

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Florian Steffen 2000-11-14 11:24:26 Time Interval Question
Previous Message dominique papin 2000-11-14 09:35:52 blobs and the toast project ?

Browse pgsql-novice by date

  From Date Subject
Next Message Mauricio Alarcon 2000-11-14 12:20:09 Replication
Previous Message Robert Lowe 2000-11-14 04:21:57 Unicode