Re: quick question abt pg_dump and restore

On 09/01/2008 14:02, Josh Harrison wrote:

> 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? Does this apply to big tables also?

If you use the text dump format, you can see the order in which the rows
are restored.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------