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

From: Matthias Apitz <guru(at)unixarea(dot)de>
To: 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 12:26:23
Message-ID: ZQBY77SKarCfnhFM@pureos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

matthias

--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Gustafsson 2023-09-12 13:10:16 Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?
Previous Message Peter J. Holzer 2023-09-12 12:19:19 Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?