| From: | Jonathan Vanasco <postgres(at)2xlp(dot)com> |
|---|---|
| To: | pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | seeking: advice on reordering table |
| Date: | 2007-04-12 04:58:52 |
| Message-ID: | AF5863FB-6BF6-4D1A-8850-39A65F6738BC@2xlp.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I've drastically altered a few tables in a major schema change.
because of this, some columns that i'd really like to be 'leftmost'
are rightmost.
can anyone suggest a good way to reorder the table ? everything that
i can think of involves creating a new table which means I'd have to
redo all the constraints .
// Jonathan Vanasco
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| SyndiClick.com
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| FindMeOn.com - The cure for Multiple Web Personality Disorder
| Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| RoadSound.com - Tools For Bands, Stuff For Fans
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Damian C | 2007-04-12 05:00:12 | Re: Unable to get a database connection while deleting rows |
| Previous Message | Patrick TJ McPhee | 2007-04-12 04:40:15 | Re: The rule question before, request official documentation on the problem |