Postgres Pro
Downloads
Home   >   mailing lists

Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random? - Mailing list pgsql-general

From Matthias Apitz
Subject Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?
Date
Msg-id ZQBY77SKarCfnhFM@pureos
Whole thread Raw
In response to Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Responses Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?
List pgsql-general
Tree view 
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@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?
Next
From: Daniel Gustafsson
Date:
Subject: Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?