dbTalk Databases Forums  

columns re-order

comp.databases.postgresql comp.databases.postgresql


Discuss columns re-order in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dade
 
Posts: n/a

Default columns re-order - 05-16-2007 , 03:12 PM






Hello all,
i've add some column to an existing table and automatically are been placed
in the bottom of the table. Is it possible to reorder the column (with
pgAdmin III) to place these columns in a more-intelligent position?

thanx
Dade



Reply With Quote
  #2  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: columns re-order - 05-18-2007 , 03:00 AM






Dade <cucca77(NOSPAM)@(nospam)gmail.com> wrote:
Quote:
i've add some column to an existing table and automatically are been placed
in the bottom of the table. Is it possible to reorder the column (with
pgAdmin III) to place these columns in a more-intelligent position?
I don't think so, but why would you need that?

In any INSERT, SELECT or COPY statement you can adjust the order of
columns as you like.

If it is important to you, you can drop and recreate the table, but
this is certainly painful.

Another thing that might help you (depending on what you want) is a
view on the table with a different column order.

Yours,
Laurenz Albe


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.