Received: from eater.zotnet.com (IDENT:root@snapuser87.pacificcrest.net [216.36.24.87]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA81694 for ; Fri, 17 Sep 1999 17:03:56 -0400 (EDT) (envelope-from zot@zotconsulting.com) Received: from zotconsulting.com (zot@mp.zotnet.com [216.36.24.118]) by eater.zotnet.com (8.8.7/8.8.7) with ESMTP id OAA20333 for ; Fri, 17 Sep 1999 14:33:02 -0700 Sender: zot@eater.zotnet.com Message-ID: <37E2ACC7.E2513AD9@zotconsulting.com> Date: Fri, 17 Sep 1999 14:04:07 -0700 From: "Zot O'Connor" Organization: Zot Consulting X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.5-15smp i686) X-Accept-Language: en MIME-Version: 1.0 To: postgres sql Subject: Converting an existing table? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I need to change the type on an existing table. From money to something else. What is the best way under postgres? I could do a query and put it in a new field and then rename the old field, and then rename the new field. I then have the old (renamed) field hanging around. Is there a cleaner way of doing this? I also need to change the length of a variable length field. -- Zot O'Connor www.ZotConsulting.com www.WhiteKnightHackers.com