Postgres Pro
Downloads
Home   >   mailing lists

Re: alter table add column - specify where the column will go? - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: alter table add column - specify where the column will go?
Date
Msg-id AANLkTin_j7LskyuFAhvbmfqYKL1=C1WE8dwTfZ-peMPO@mail.gmail.com
Whole thread Raw
In response to Re: alter table add column - specify where the column will go?  (Dmitriy Igrishin <dmitigr@gmail.com>)
Responses Re: alter table add column - specify where the column will go?  (Thomas Kellerer <spam_eater@gmx.net>)
Re: alter table add column - specify where the column will go?  (Peter Bex <Peter.Bex@xs4all.nl>)
Re: alter table add column - specify where the column will go?  (Dmitriy Igrishin <dmitigr@gmail.com>)
Re: alter table add column - specify where the column will go?  (Florian Weimer <fweimer@bfk.de>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Mark Morgan Lloyd
Date:
Subject: Getting current and average on a single row
Next
From: Thomas Kellerer
Date:
Subject: Re: alter table add column - specify where the column will go?