John McCawley <nospam@xxxxxxxxxxxx> schrieb: > However, in the real world, columns are often added willy-nilly as they are > needed, and it is not immediately obvious which, if any, of the columns > will be related. Later, solely for visual clarity, it is desirable to have > the ability to reorder the columns in the database. I wouldn't depend on I understand you, but i repeat Joshua and Berend: PostgreSQL hasn't a build-in solution for this. And i think, other systems do this: - begin - create a new temp. table with the new order - insert all values from the old table in the new temp. table - drop the old table - rename the temp. table to the old table name - commit You can do the same, no problem. HTH, Andreas, and sorry for my bad english -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
