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@xxxxxx
---------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
