Received: from odysseus1.dohle.com (root@odysseus1.dohle.com [194.127.185.21]) by hub.org (8.10.1/8.10.1) with ESMTP id e6B7T2W06578 for ; Tue, 11 Jul 2000 03:29:02 -0400 (EDT) Received: from majestix.dohle.com (majestix.dohle.com [194.127.190.1]) by odysseus1.dohle.com (8.9.3/8.9.3) with SMTP id JAA14124 for ; Tue, 11 Jul 2000 09:28:58 +0200 Received: from wpaul.dohle.com by majestix.dohle.com id aa05140; 11 Jul 100 9:28 CETDST Message-ID: <396ACD65.5E91F1E5@dohle.com> Date: Tue, 11 Jul 2000 09:31:49 +0200 From: Volker Paul Organization: Dohle Handelsgruppe Systemberatung GmbH X-Mailer: Mozilla 4.05 [en] (WinNT; I) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Change type of column Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/119 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