The world rejoiced as ignacio.colmenero@xxxxxxxxxxx ("Ignacio Colmenero") wrote:
[Large amount of HTML removed... _Please_ post in plain text...]
There is no direct analogue to Oracle's SQL*Loader product for
PostgreSQL at this time.
That being said...
1. Plenty of scripting languages are available for Unix platforms,
and they are plenty good at "massaging" data.
2. I recall Jan Wieck having created a Tcl-based "load tool"
prototype about a year ago that had capabilities somewhat resembling
SQL*Loader. (Very "somewhat" :-).) It sort of disappeared, which is
a bit of a shame. It might be possible to convince him to put that up
on GBorg or PGFoundry. It's a tool someone else should take on at
this point in time; the ideas, at least, could help in building such a
tool.
3. Pervasive Software seems to have some Windows-based tools they are
releasing for doing ETL. That might be useful.
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','ntlug.org').
http://linuxdatabases.info/~cbbrowne/languages.html
But what can you do with it? -- ubiquitous cry from Linux-user
partner. -- Andy Pearce, <ajp@xxxxxxxxxxxxxxxx>
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
