Question about COPY to/from

[Emi Lu <emilu@xxxxxxxxxxxxxxxxx>]

Hello,

We have millions of record and would like to insert into a table. I 
remebered people mentioned that "COPY" is the most effecient way to 
insert data, right? If not, which is it, pg_restore?

By the way, does it have to be superuser to run copy to and from?

Thanks a lot,
Emi