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.
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.