Default order on displaying data without order clause

Поиск
Список
Период
Сортировка
От Janus
Тема Default order on displaying data without order clause
Дата
Msg-id CAJTmWxiEPk13Df75uVJgHaKB4rK4LrfzrxApE5tgO6-7dNA38g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Default order on displaying data without order clause  (Wim Bertels <wim.bertels@ucll.be>)
Список 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 по дате отправления:

Предыдущее
От: Isaias Sanchez
Дата:
Сообщение: Re: Could you please advise how to set the csv download path? Thanks.
Следующее
От: Wim Bertels
Дата:
Сообщение: Re: Default order on displaying data without order clause