Thanks.
I guess I could add that logic, but this is a one time process going to run the night we go live on postgres. With .net it took like 2 hours to do the whole shebang, so I am happy.
Fair enough. I tend to produce a text-file and use COPY for bulk transfers, but that's just me.
I did convert a fairly large app and it seemed to run faster on the postgres box then the MSSQL box, so my first project after actually getting the data and views has gone very smooth.
Don't forget to set aside some time for tweaking configuration settings so you can tune the system.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
