Column order

From: "Vyacheslav Kalinin" <vka(at)mgcp(dot)com>
To: PGSQL <pgsql-general(at)postgresql(dot)org>
Subject: Column order
Date: 2008-04-24 01:33:21
Message-ID: 9b1af80e0804231833s655296a5m3c7f8e3f4d5fd8eb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

It is often convenient to have columns of a table in certain order (as shown
by psql or most GUI database explorers, it also affects INSERT's
without columns specified behavior) so as to most significant columns
to
come first, semantically close columns to be grouped etc, while the columns
might be added to the table in different order during development
process. So, the question is - is it an acceptable way to play with
pg_attribute's attnum and set it to needed value
or recreate the table is the only
way? On the related note - should the columns necessarily be numbered
from 1 up with the step of 1?

Thanks,
Viatcheslav

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2008-04-24 01:49:26 Re: Column order
Previous Message Dann Corbit 2008-04-24 00:02:30 Re: Need to update all my 60 million rows at once without transactional integrity