Re: quick question abt pg_dump and restore - Mailing list pgsql-general

From Josh Harrison
Subject Re: quick question abt pg_dump and restore
Date
Msg-id 8d89ea1d0801090717m60ceb1e2wf7489d82b34fbfae@mail.gmail.com
Whole thread Raw
In response to Re: quick question abt pg_dump and restore  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: quick question abt pg_dump and restore  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general


On Jan 9, 2008 9:59 AM, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:
am  Wed, dem 09.01.2008, um  9:45:11 -0500 mailte Josh Harrison folgendes:
> 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 ???

For what reason?

Again: there is no order within the database.

Thanks...
Another quick question...When you issue a query like this
select * from dummy limit 10
What 10 rows are fetched? like first 10  or last 10 or  the first 10 from first block or.... ?
And this query always returns the same 10 rows (when there are no updates/deletes)


josh

pgsql-general by date:

Previous
From: "x asasaxax"
Date:
Subject: Re: XML path function
Next
From: Sim Zacks
Date:
Subject: Re: Experiences with extensibility