[EMAIL PROTECTED] wrote: > > The table I have is something like > CREATE TABLE sn2uid( > sn VARCHAR(100) NOT NULL, > uid INTEGER NOT NULL, > PRIMARY KEY (sn) > ); > CREATE INDEX uidindex on sn2uid ( uid ) > > > is there a way to do a select or a .dump so that when inserting the > data on the other end, things will be faster?
Do BEGIN EXCLUSIVE, then copy the disk file, then do COMMIT. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------