Jie Liang <jie@stbernard.com> writes:
> pg_restore give admin a lot of flexabilities, it can restore any object
> from a single dump file. But if the table is very big, e.g. 2M records,
> it will take a long time to restore because it use INSERTs.
This is demonstrably not the case --- at least not by default. You
get the same commands you would've gotten from pg_dump. Sure you
didn't create the dump file with "-d" ?
regards, tom lane