From: | Chris Campbell <ccampbell(at)cascadeds(dot)com> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Changing Field Ordinal Position |
Date: | 2010-10-22 17:38:30 |
Message-ID: | 453A24085F801842AEA8D0B6B269065D301F8C4C10@HDMC.cds.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Using PostgreSQL 9.0.1
Hi, is it possible to change the ordinal position of fields in a table, or, more specifically, be able to specify the ordinal position when adding new fields to a table. I see that each field has a property called "position" yet there seems to be no way to change it, or, when fields are dropped from a table does it seem to update.
I looked at the ALTER [ COLUMN ] column SET ( attribute_option = value [, ... ] ) and RESET ( attribute_option [, ... ] ) but according to the documentation this only applies to n_distinct and n_distinct_inherited properties. Thank you for any assistance...
Chris Campbell
Cascade Data Solutions, Inc.
ccampbell(at)CascadeDS(dot)com
(800) 280-2090
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2010-10-22 17:49:13 | Re: Changing Field Ordinal Position |
Previous Message | Frank Bax | 2010-10-22 11:24:33 | Re: "duplicate key value": version 8.4 vs 8.1 |