X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 10BD1D1B4E1 for ; Mon, 27 Oct 2003 17:47:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 95369-05 for ; Mon, 27 Oct 2003 13:46:48 -0400 (AST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by svr1.postgresql.org (Postfix) with ESMTP id 61822D1B4F9 for ; Mon, 27 Oct 2003 13:46:43 -0400 (AST) Received: from klaster.net (core-1.citynet.pl [80.48.135.69]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 929D32B3CB; Mon, 27 Oct 2003 18:46:03 +0100 (CET) Message-ID: <3F9D59FC.8010407@klaster.net> Date: Mon, 27 Oct 2003 18:46:36 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; pl-PL; rv:1.5) Gecko/20030916 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: mohan@physics.gmu.edu Cc: pgsql-sql@postgresql.org Subject: Re: URGENT!!! changing Column size References: <64184.138.88.163.115.1067274631.squirrel@physics.gmu.edu> In-Reply-To: <64184.138.88.163.115.1067274631.squirrel@physics.gmu.edu> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/345 X-Sequence-Number: 15745 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