Quick Links

Re: alter table add column - specify where the column will go?

From:	Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To:	Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
Cc:	Alexander Farber <alexander(dot)farber(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject:	Re: alter table add column - specify where the column will go?
Date:	2010-11-24 09:37:02
Message-ID:	AANLkTin_j7LskyuFAhvbmfqYKL1=C1WE8dwTfZ-peMPO@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

just never use SELECT *, but always call columns by names. You'll
avoid having to depend on the order of columns, which is never
guaranteed, even if the table on disk is one order, the return columns
could be in some other.

In response to

Re: alter table add column - specify where the column will go? at 2010-11-24 08:22:20 from Dmitriy Igrishin

Responses

Re: alter table add column - specify where the column will go? at 2010-11-24 09:43:16 from Thomas Kellerer
Re: alter table add column - specify where the column will go? at 2010-11-24 10:32:44 from Peter Bex
Re: alter table add column - specify where the column will go? at 2010-11-24 10:45:23 from Dmitriy Igrishin
Re: alter table add column - specify where the column will go? at 2010-11-24 11:06:09 from Florian Weimer

Browse pgsql-general by date

	From	Date	Subject
Next Message	Thomas Kellerer	2010-11-24 09:43:16	Re: alter table add column - specify where the column will go?
Previous Message	Mark Morgan Lloyd	2010-11-24 09:08:27	Getting current and average on a single row