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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
