DBeaver
How Can I sort the column names , I am using Postgres and Deaver Enterprise 7.3.0. #10670
-
System information:
Connection specification:
Describe your question: |
Beta Was this translation helpful? Give feedback.
Replies: 6 comments 2 replies
-
|
Hi @jota2406 , |
Beta Was this translation helpful? Give feedback.
-
|
I might misunderstand what do you want to achieve, but what if you simple write the select query in that order? |
Beta Was this translation helpful? Give feedback.
-
|
You can't change column order in postgres because it is not supported by the database. You can reorder columns in DBeaver when you view table data and save it as a filter to be remembered but this will only affect your DBeaver view, it will not be saved in the database. |
Beta Was this translation helpful? Give feedback.
-
|
What if I don't want to change the underlying column order, but I just want to see the columns in a different/alphabetic order in the data view? I usually pin columns that I'm interested, but for a table with many columns, it can be sometimes be hard to find a particular column. Note, I don't need this to be supported by the database. I don't want the database column order to change, just for DBeaver to change what I'm looking at. |
Beta Was this translation helpful? Give feedback.
-
|
I using Sql Manager Lite for Postgres SQL 6.1.2 and I can reorder columns easily in the database and I don't have any problem to reorder columns , so I expected to do the same in DBeaver. |
Beta Was this translation helpful? Give feedback.
-
|
Yes, but it doesn't change the fact that Postgres does not support reordering columns. Sql Manager uses certain tricks to do it and as it is stated on their web site it does not work in all cases. At best you can request this feature from DBeaver devs but this may not be easy to implement unless done only for the most simple cases like tables without relations, etc. |
Beta Was this translation helpful? Give feedback.
-
|
Yes, you are right, I going to request that because this feature it´s very important even only for only tables without relations. |
Beta Was this translation helpful? Give feedback.
You can't change column order in postgres because it is not supported by the database. You can reorder columns in DBeaver when you view table data and save it as a filter to be remembered but this will only affect your DBeaver view, it will not be saved in the database.