Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Matthias Apitz <guru(at)unixarea(dot)de>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?
Date: 2023-09-12 13:10:16
Message-ID: 903B39F6-3530-4299-A0D5-19DCD8B0D8B5@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On 12 Sep 2023, at 14:26, Matthias Apitz <guru(at)unixarea(dot)de> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message DAVID ROTH 2023-09-12 13:24:14 Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?
Previous Message Matthias Apitz 2023-09-12 12:26:23 Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?