clicking on table header in 'results view' always jumps back to results of SQL statement

[vanHoesel]

Although that is exactly what has been described in the documentation, the behaviour sometimes is unexpected, or even undesirable.

When I double click on a table name in the 'outline navigator' it shows me in the results of a SELECT * FROM, that is pretty much expected.
However, when I expand the tabel in the 'outline navigator' I see 'columns', 'pseudo columns', 'indices', and 'keys'. Then, double clicking on 'Columns' gives me all the column definitions in the 'result view', nice. But then when I click in the table header on 'table name', it returns me the records in the table, not a 'sort', which is the usual behaviour.

It's quite obvious what is happening, for the 'Query Editor' now shows things like: SELECT * FROM "public"."my_interesting_table" ORDER BY 3 ASC (where 3 is the column called 'table name').

This unexpected behaviour is present at multiple places, like Keys, primary/imported/exported.