[EMAIL PROTECTED] wrote, On 10/27/2003 6:10 PM:
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.
1 solution:
begin; create temporary table temp as select * from mytable; drop table mytable; create table mytable (name varchar(50)); insert into mytable select CAST(name AS varchar(50)) from temp; drop table temp; commit;
C.
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
