Dnia 2003-10-27 18:10, Użytkownik mohan@physics.gmu.edu napisał:
> Hi can we change the size of a column in postgres. I have a table named
> institution and column name is name varchar2(25), i want to change it to
> varchar2(50). Please let me know.
alter table institution add column tmp varchar2(50);
update institution set tmp=name;
alter table institution drop column name;
alter table institution rename tmp to name;
(or something like this)
Regards,
Tomasz Myrta