Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YnOk9-0004V7-Ds for pgsql-admin@arkaria.postgresql.org; Wed, 29 Apr 2015 09:57:25 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YnOk8-00020E-Me for pgsql-admin@arkaria.postgresql.org; Wed, 29 Apr 2015 09:57:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YnOk7-000208-UI for pgsql-admin@postgresql.org; Wed, 29 Apr 2015 09:57:23 +0000 Received: from mout.web.de ([212.227.17.12]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YnOk3-0007JS-Rv for pgsql-admin@postgresql.org; Wed, 29 Apr 2015 09:57:23 +0000 Received: from vm-mailsrv.lan.net ([87.155.127.87]) by smtp.web.de (mrweb101) with ESMTPSA (Nemesis) id 0LyDdJ-1ZJUPA0TET-015cZL; Wed, 29 Apr 2015 11:57:17 +0200 Received: from localhost (localhost [127.0.0.1]) by vm-mailsrv.lan.net (Postfix) with ESMTP id D3FF4DF9D; Wed, 29 Apr 2015 11:57:15 +0200 (CEST) X-Spam-Flag: NO X-Spam-Score: -2.898 X-Spam-Level: X-Spam-Status: No, score=-2.898 tagged_above=-99.9 required=6.31 tests=[ALL_TRUSTED=-1, BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=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 YFf8LbyiNI7T; Wed, 29 Apr 2015 11:57:12 +0200 (CEST) Received: from [10.94.76.50] (ipad.lan.net [10.94.76.50]) by vm-mailsrv.lan.net (Postfix) with ESMTP id BD476F12B; Wed, 29 Apr 2015 11:57:12 +0200 (CEST) Content-Type: multipart/alternative; boundary=Apple-Mail-04AEE172-0F7F-43BA-9563-F54A77461F91 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:57:12 +0200 Cc: pgsql-admin Content-Transfer-Encoding: 7bit Message-Id: <8BEDDDB7-AE65-41D4-B778-9C4156564322@web.de> References: <448DB0A2-7D1A-4D27-B97A-EF8812278FD2@web.de> To: Ankur Kaushik X-Provags-ID: V03:K0:MAzyIRfzeQGrAmef1BPZxxw0tJWA0c6cCPBni7mIBKadR4I9vVs utnG0Qym2qdM9COLM5q3CEJKXm+VTRJxH3huxFZW7aT6HssvZ8h8kfXMFpXK3M5pl6KVK8n R6sLRRmBrqP/X1QfwnOC8I13jrt9JZU5fgBB2Evvb1vK9Hp8skyRNaA5uGNbZFLO52Wbns9 peMlq0nnfrH/fR0ZvW6NQ== 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 --Apple-Mail-04AEE172-0F7F-43BA-9563-F54A77461F91 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable None that I am aware of. But from my experience, order does not really matte= r. Von meinem iPad gesendet > Am 29.04.2015 um 11:53 schrieb Ankur Kaushik : >=20 >=20 > So Any Other way Apart from Recreating the table structure ? >=20 >> On Wed, Apr 29, 2015 at 3:21 PM, Jan Lentfer wrote: >> Hi, this is not currently possibly with just an ALTER TABLE. Regards, Jan= . >>=20 >> Von meinem iPad gesendet >>=20 >> > 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. >=20 --Apple-Mail-04AEE172-0F7F-43BA-9563-F54A77461F91 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit
None that I am aware of. But from my experience, order does not really matter.

Von meinem iPad gesendet

Am 29.04.2015 um 11:53 schrieb Ankur Kaushik <ankurkaushik@gmail.com>:


So Any Other way Apart from Recreating the table structure ?

On Wed, Apr 29, 2015 at 3:21 PM, Jan Lentfer <Jan.Lentfer@web.de> wrote:
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 <ankurkaushik@gmail.com>:
>
>
> 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.

--Apple-Mail-04AEE172-0F7F-43BA-9563-F54A77461F91--