> On 12 Sep 2023, at 14:26, Matthias Apitz <guru@xxxxxxxxxxx> wrote: > > El día martes, septiembre 12, 2023 a las 02:19:19 +0200, Peter J. Holzer escribió: > >>> - Or can we add additional parameters to the ora2pg.conf file to control this >>> process and ensure that the data is imported sequentially, following the >>> primary key from smallest to largest? > > AFAIK, a simple SELECT in PostgreSQL without an ORDER BY will return the rows > in random order. It will return the rows in some order, without guarantees about randomness or asc/desc ordering. Any query which relies on ordering, whichever is wanted, should include an ORDER BY clause. -- Daniel Gustafsson
