Finally--a question I think I can answer!
You need to specify what delimiters you use in your
.dat file; the default for COPY is tab, but you can
change that to | with
copy tablename from '/home/ed/import.dat'
delimiters '|'
Hope this works...(oops--I mean 'helps')
--- Ed [EMAIL
Hi all,
Does anybody have any thoughts on optimizing a huge
insert, involving something like 3 million records all
at once? Should I drop my indices before doing the
copy, and then create them after? I keep a
tab-delimited file as a buffer, copy it, then do it
again about 400 times. Each
as NOT NULL already, adding a unique index to the
columns in question has the same general effect.
Stephan Szabo
[EMAIL PROTECTED]
On Tue, 29 Aug 2000, Webb Sprague wrote:
Apropos of my last question:
Is there syntax to create a primary key after the
table has been defined
I am experimenting with this too. If I have any
indexes at all, the copy's get VERY SLOW as the table
gets big. Delete ALL your indexes, do your copy's,
and then create your indexes again.
Good luck.
--- Jie Liang [EMAIL PROTECTED] wrote:
Hi, there,
I tried different ways, include vaccum
Hi all,
How do I convert from seconds (an integer) to
timestamp?
I am sure it is easy, but I can't find it in the docs,
so far.
Thanks
Webb
__
Do You Yahoo!?
Send instant messages get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
.
Thanks,
--
Webb Sprague
Programmer
O1 Communications
