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