Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 293689FBA40 for ; Thu, 15 Mar 2007 10:46:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 57355-01 for ; Thu, 15 Mar 2007 10:46:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.188]) by postgresql.org (Postfix) with ESMTP id 23D049FBA2E for ; Thu, 15 Mar 2007 10:46:48 -0300 (ADT) Received: from [194.25.154.138] (helo=webserv.wug.de) by mrelayeu.kundenserver.de (node=mrelayeu4) with ESMTP (Nemesis), id 0ML21M-1HRqHz3Jjd-0003V9; Thu, 15 Mar 2007 14:46:44 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1HRqHx-00024v-00 for pgsql-sql@postgresql.org; Thu, 15 Mar 2007 14:46:41 +0100 Date: Thu, 15 Mar 2007 14:46:41 +0100 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: Alter Table Message-ID: <20070315134641.GB30222@a-kretschmer.de> References: <00de01c76706$d37d56e0$1102a8c0@dream> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <00de01c76706$d37d56e0$1102a8c0@dream> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the answer is "no"! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX19r+3Tenb5/jCP8+wTSfwjprbOiG6upfpuA5ED oHVtVGdVOmvsleJePS2/MHPqBsDsw87gLq3BIX1KRhxeidOp/t 1e39OKrO3UQObpVaX70JgJJfEx6iJCZ X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/210 X-Sequence-Number: 27848 am Thu, dem 15.03.2007, um 14:35:41 +0100 mailte Shavonne Marietta Wijesinghe folgendes: > When i alter a table and add a new column it always adds it to the end of the > table. Is there any way to tell it to add the new column at the 5th position or > to add the new column after a surtain column. No, but you can (and should) define the column-order in the select-statement. Other solutions: - define a VIEW - recreate the table Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net