Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YnOf4-0004DJ-CI for pgsql-admin@arkaria.postgresql.org; Wed, 29 Apr 2015 09:52:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YnOf3-0008OF-Oe for pgsql-admin@arkaria.postgresql.org; Wed, 29 Apr 2015 09:52:09 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YnOf2-0008O8-KC for pgsql-admin@postgresql.org; Wed, 29 Apr 2015 09:52:08 +0000 Received: from mout.web.de ([212.227.15.4]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.84) (envelope-from ) id 1YnOez-00010V-PB for pgsql-admin@postgresql.org; Wed, 29 Apr 2015 09:52:07 +0000 Received: from vm-mailsrv.lan.net ([87.155.127.87]) by smtp.web.de (mrweb004) with ESMTPSA (Nemesis) id 0Lg3bv-1ZcejJ0qex-00paWN; Wed, 29 Apr 2015 11:52:02 +0200 Received: from localhost (localhost [127.0.0.1]) by vm-mailsrv.lan.net (Postfix) with ESMTP id F220FDF9D; Wed, 29 Apr 2015 11:52:00 +0200 (CEST) X-Spam-Flag: NO X-Spam-Score: -2.899 X-Spam-Level: X-Spam-Status: No, score=-2.899 tagged_above=-99.9 required=6.31 tests=[ALL_TRUSTED=-1, BAYES_00=-1.9, FREEMAIL_FROM=0.001] autolearn=ham Received: from vm-mailsrv.lan.net ([127.0.0.1]) by localhost (vm-mailsrv.lan.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id MiPBxYeAMM4t; Wed, 29 Apr 2015 11:51:58 +0200 (CEST) Received: from [10.94.76.50] (ipad.lan.net [10.94.76.50]) by vm-mailsrv.lan.net (Postfix) with ESMTP id 4F24BF12B; Wed, 29 Apr 2015 11:51:58 +0200 (CEST) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (1.0) Subject: Re: Adding Column in Specific Position of table From: Jan Lentfer X-Mailer: iPad Mail (12D508) In-Reply-To: Date: Wed, 29 Apr 2015 11:51:58 +0200 Cc: "pgsql-admin@postgresql.org" Content-Transfer-Encoding: 7bit Message-Id: <448DB0A2-7D1A-4D27-B97A-EF8812278FD2@web.de> References: To: Ankur Kaushik X-Provags-ID: V03:K0:tseiccBDSbrX0oRqIbCANpvBt4EAtCoq+u1r5BTpgDdwrI8A9T+ ZS4AZbBYJGHqZ8IIFCxy/E5V79flZ1Uu+Gn+PEc2AZIXx1YCNaulU78YiNU8zPRtLTwGmM4 L33KVyd/l09htP67/JtDqitZpt94iZvQ5Vb+iqFmy1w6JWT2jEJs3Lw2aAjVzIlDb1ZDOGD CsKRzBN69Xfstfboq8UwA== X-UI-Out-Filterresults: notjunk:1; X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hi, this is not currently possibly with just an ALTER TABLE. Regards, Jan. Von meinem iPad gesendet > Am 29.04.2015 um 11:43 schrieb Ankur Kaushik : > > > Hi , > > I can I alter table to add column at specific position , > > below > > Table : Post > > > Column : a > b > d > > Want to add new column c before d or after b. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin