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
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
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
Hi Team,
How can we rearrange the column of PostgreSQL using PGADMIN?
--
Best Regards,
Sachin Kumar