Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group