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(at)iol(dot)ie
---------------------------------------------------------------