Received: from megazone.bigpanda.com ([63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB6GV4m72401 for ; Thu, 6 Dec 2001 11:31:04 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 87D2FD5EC; Thu, 6 Dec 2001 08:31:09 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 7D8575BED; Thu, 6 Dec 2001 08:31:09 -0800 (PST) Date: Thu, 6 Dec 2001 08:31:09 -0800 (PST) From: Stephan Szabo To: tinar Cc: Subject: Re: how to chane the type In-Reply-To: Message-ID: <20011206082604.Y25449-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200112/78 X-Sequence-Number: 5901 On Wed, 5 Dec 2001, tinar wrote: > i have created a table > userlist with fields username varchar(10) > now i want to change it to username varchar(30) > without dropping or recreating the table. > how do i do it? The best way is to recreate the table and rename them around. If you *REALLY* don't want to do that and have a recent backup (yes, I'm serious), you can muck with pg_attribute and change atttypmod for the attribute in question (from 14 to 34).