From: | "Josh Harrison" <joshques(at)gmail(dot)com> |
---|---|
To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: quick question abt pg_dump and restore |
Date: | 2008-01-09 14:45:11 |
Message-ID: | 8d89ea1d0801090645j4e6c7n5e67d0ed82cbe2b5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Jan 9, 2008 9:12 AM, A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com>
wrote:
> am Wed, dem 09.01.2008, um 9:02:23 -0500 mailte Josh Harrison folgendes:
> > Hi,
> > When restoring the pg_dumped data thro psql does the rows of the table
> are
> > restored in the same order? ie for example if
> > Table A has rows r1,r2,r3,r4,r5 in this order, then if I pg_dump and
> restore it
> > to another database, will it have the rows in the same order
> r1,r2,r3,r4,r5?
>
> No. If you need an order than you need an ORDER BY in the
> SELECT-Statement.
>
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 ???
Thanks
josh
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-01-09 14:50:57 | Re: quick question abt pg_dump and restore |
Previous Message | A. Kretschmer | 2008-01-09 14:35:54 | Re: quick question abt pg_dump and restore |