Thread: 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: > 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 ?