Support edit order of the fields in table

On Thu, 2023-06-01 at 00:31 +0800, Chang Wei 昌維 wrote:

Hi Postgres community: I think support editing order of the fields in
table is a useful feature. I have known that the order of fields will
effect the data structure of rows data, but I think we could add a extra
information to identify the display order of fields but not effect the
rows data, and the order identification is only used to display in order
while execute `SELECT * FROM [table_name]` and display the table
structure on GUI tools like pgAdmin.

Now, we must create a new view and define the order of fields if we need
to display the fields of  table in a order of our demand, it is not a
good way.

But PostgreSQL tables are not spreadsheets. When, except in the display of
the result of interactive queries, would the order matter?

Yours,
Laurenz Albe