Forum Overview :: Deleted Posts :: Re: I'll try to handle this. Speak his language.

[quote name="jeep"][quote name="Ray of Light"][quote name="jeep"]The rule is: if you're going to do it twice, write a program. You're only going to do this once.[/quote] Haha what now? I think "once each, for ten thousand posts" also qualifies for the program. Ray! [/quote] when you export it from postgres, it makes a text file whatever.sql. You can just run regexp replacements on it until it does what you want. For a one-time process of iterating 10000 tiny chunks of text, a text editor with regexp is the "program." I'm a lazy bastard, so I have to know when it's easier to write a script or use a text editor to massage the data. I also have to know when other people wrote stuff to do the heavy lifting for me, even if the apps are cheesy. Since he's no going to be dealing with the consequences of SB_PG_Crazy.sql more than once, is there really a point to writing an application for it? You'll only ever have one blob of data to do this with. Do you expect anyone here will have to move pgsql -> mysql a lot in the future? /jeep/[/quote]