Re: Rearrange Column

2021-04-22 Thread richard coleman
Dave, Thanks, yes I got that, and the OP may indeed have wanted info on the *reporting* results. Since pgAdmin4 lets one administer/create/manipulate the postgreSQL database/tables/views/etc. rearranging the underlying table (much like Microsoft SQL Management Studio lets you do with a MS MQL dat

Re: Rearrange Column

2021-04-22 Thread Dave Caughey
Rik, Clearly, if you do SELECT colA, colB FROM MyTable vs SELECT colB, colA FROM MyTable you'll get the results in a different sequence. Obviously, using this approach has not manipulated the underlying table (your interpretation of what the OP is asking for), but perhaps the OP's question is

Re: Rearrange Column

2021-04-22 Thread richard coleman
Sachin, Umm, I hate to be the one to break it to you, but *postgreSQL *doesn't support rearranging columns in a table, short of dropping them and re-adding them in the desired order. Since postgreSQL itself doesn't support that, I would be truly amazed to learn that pgAdmin4 managed to accomplish

Rearrange Column

2021-04-22 Thread Sachin Kumar
Hi Team, How can we rearrange the column of PostgreSQL using PGADMIN? -- Best Regards, Sachin Kumar