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 3D027D1B50B for ; Tue, 28 Oct 2003 13:01:24 +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 83872-02 for ; Tue, 28 Oct 2003 09:00:56 -0400 (AST) Received: from web41010.mail.yahoo.com (web41010.mail.yahoo.com [66.218.93.9]) by svr1.postgresql.org (Postfix) with SMTP id EDB71D1B4E6 for ; Tue, 28 Oct 2003 09:00:52 -0400 (AST) Message-ID: <20031028130052.54133.qmail@web41010.mail.yahoo.com> Received: from [66.108.25.20] by web41010.mail.yahoo.com via HTTP; Tue, 28 Oct 2003 05:00:52 PST Date: Tue, 28 Oct 2003 05:00:52 -0800 (PST) From: Theodore Petrosky Subject: Re: URGENT!!! changing Column size To: mohan@physics.gmu.edu, pgsql-sql@postgresql.org In-Reply-To: <64184.138.88.163.115.1067274631.squirrel@physics.gmu.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/358 X-Sequence-Number: 15758 why not just pg_dump dbname > olddb.out pico olddb.out edit the section that defines the table save and exit dropdb dbname createdb dbname psql dbname < olddb.out no fuss no muss... Ted --- mohan@physics.gmu.edu wrote: > 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. > > --Mohan > > > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the > unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/