smallint to bigint
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
Micka�l Jouanne writes:
but i want to change smallint to bigint without droping the table.
Can't do that.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
About all you can do is make a new table with the structure
you want and use insert into to copy the data and then alter
table to rename the tables in place. (One note though, if
you're trying to go from int2 to int8 it's kind of unhappy
for one step, you'll need to promote to int4 and then to int8
in the select).
Stephan Szabo
sszabo@bigpanda.com
On Tue, 14 Nov 2000, [iso-8859-1] Micka���l Jouanne wrote:
Show quoted text
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 ?