Now that I've got a whole table in, I can look at pg_dump's output and see how it does it.
Ah... *that's* how to use COPY... I think I'll be writing my own dump tool to do the data migration.
Wade.
FullText indices in MySQL.
- (static)
- (17)
- Jan. 10, 2006, 11:07:46 PM EST
Re: FullText indices in MySQL.
- (admin)
- (3)
- Jan. 10, 2006, 11:09:46 PM EST
It's a political reason.
- (static)
- (2)
- Jan. 10, 2006, 11:23:40 PM EST
Boggle.
- (admin)
- (1)
- Jan. 10, 2006, 11:18:38 PM EST
Believe me, I want to try it.
- (static)
- Jan. 10, 2006, 11:26:30 PM EST
DB2->Bummer
- (tuberculosis)
- (12)
- Jan. 11, 2006, 07:04:38 PM EST
And porting from Postgres -> Oracle is likely to be easy
- (drewk)
- (1)
- Jan. 11, 2006, 07:14:09 PM EST
I've gone the other way - not too hard - pretty close
-NT
- (tuberculosis)
- Jan. 11, 2006, 07:57:21 PM EST
PostGreSQL may be on the cards again.
- (static)
- (9)
- Jan. 11, 2006, 10:10:00 PM EST
For faster COPYs
- (admin)
- (1)
- Jan. 11, 2006, 10:44:37 PM EST
Been trying to figure out how to do that.
- (static)
- Jan. 11, 2006, 11:36:35 PM EST
Copy is slow?
- (broomberg)
- (6)
- Jan. 11, 2006, 10:59:58 PM EST
Well, I'm doing a psql < filename.sql
- (static)
- (5)
- Jan. 11, 2006, 11:24:58 PM EST
Explain the copy command you are using
- (broomberg)
- (4)
- Jan. 11, 2006, 11:32:05 PM EST
I wasn't using COPY at all.
- (static)
- (3)
- Jan. 11, 2006, 11:38:57 PM EST
Huh?
- (broomberg)
- (2)
- Jan. 11, 2006, 11:50:35 PM EST
I didn't *know* about it. :-)
- (static)
- (1)
- Jan. 12, 2006, 12:02:20 AM EST
Oh, OK
- (broomberg)
- Jan. 12, 2006, 12:22:59 AM EST