Re: quick question abt pg_dump and restore

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Josh Harrison escribi:
>> Fine. I can use order by when I want to order it in terms of some columns.
>> But What if I want to maintain the same order as in the database1? ie., I
>> want my rows of TableABC in Database2 to be the same order as the rows in
>> TableABC in Database 1 ???

> You can't.

According to the SQL standard, a table is an *unordered* collection of
rows, and the results of any query are produced in an unspecified order
(unless you use ORDER BY). The ambiguity about row ordering is
intentional and is exploited by most DBMSes including Postgres to
improve implementation efficiency. If you assume there is such a thing
as a specific ordering within a table, you'll live to regret it
eventually.

regards, tom lane