Hi Stephen,
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?
COPY is what you
Emi Lu [EMAIL PROTECTED] writes:
However, running psql -d db -h ... from STDID, I believe we are
forced to type the password through prompt command line. Since our data
population task is through cronjob, is there a way, we can run COPY ...
STDIN by explicitly specifying password so that
On Mon, 2006-02-20 at 16:39, Emi Lu wrote:
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?
Take a look inside a pg_dump output and guess what
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
* Emi Lu ([EMAIL PROTECTED]) wrote:
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?