[GENERAL] Question about COPY to/from

[Emi Lu]

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



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org