Received: from mail.rdc2.bc.home.com (ha1.rdc2.bc.wave.home.com [24.2.10.68]) by hub.org (8.10.1/8.10.1) with ESMTP id e6BGScW76871 for ; Tue, 11 Jul 2000 12:28:39 -0400 (EDT) Received: from cr699264a ([24.113.17.57]) by mail2.rdc2.bc.home.com (InterMail vM.4.01.03.00 201-229-121) with SMTP id <20000711154335.XYFA9731.mail2.rdc2.bc.home.com@cr699264a> for ; Tue, 11 Jul 2000 08:43:35 -0700 From: "Rob S." To: Subject: RE: Change type of column Date: Tue, 11 Jul 2000 08:45:45 -0700 Message-ID: <002d01bfeb4f$13ab4b40$39117118@rct1.bc.wave.home.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Importance: Normal In-Reply-To: <396ACD65.5E91F1E5@dohle.com> X-Archive-Number: 200007/121 I think this is in the FAQ. I was reading it last nite and I believe there's something in there that might be relevant. - r > -----Original Message----- > From: pgsql-sql-owner@hub.org [mailto:pgsql-sql-owner@hub.org]On Behalf > Of Volker Paul > Sent: July 11, 2000 12:32 AM > To: pgsql-sql@postgresql.org > Subject: [SQL] Change type of column > > > Hello, > > how can I change the type of a column, e.g. from varchar() to text? > Or is it possible to drop (i.e. delete) a column without > creating a new table from the old one but without that column, > dropping the old table and renaming the old to the new? > > Thanks, > > Volker Paul >