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
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 |