Default order on displaying data without order clause - Mailing list pgadmin-support

From Janus
Subject Default order on displaying data without order clause
Date
Msg-id CAJTmWxiEPk13Df75uVJgHaKB4rK4LrfzrxApE5tgO6-7dNA38g@mail.gmail.com
Whole thread Raw
Responses Re: Default order on displaying data without order clause  (Wim Bertels <wim.bertels@ucll.be>)
List pgadmin-support
In pgAdmin 3, an implicit default order by primary key is used when displaying data without an otherwise stated order. This is not the case in pgAdmin 4. The order seems somewhat arbitrary and the following statement from this site is definitely not true: "When you query data from a table, PostgreSQL returns the rows in the order that they were inserted into the table."

I do understand that some order of course exists, but from a human perspective it would make sense that default ordering is by PK, unless stated otherwise. In PgAdmin 4, is it possible to set a default ordering, at least so that displaying a table's contents using the "View Data" button, i.e. the query being run is altered from "SELECT oid, * FROM public.mytable" to "SELECT oid, * FROM public.mytable ORDER BY <primary key(s)>"?

Thanks!

pgadmin-support by date:

Previous
From: Isaias Sanchez
Date:
Subject: Re: Could you please advise how to set the csv download path? Thanks.
Next
From: Wim Bertels
Date:
Subject: Re: Default order on displaying data without order clause