Re: Questions about functionality

The world rejoiced as ignacio(dot)colmenero(at)micotan(dot)com ("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(at)hpopd(dot)pwd(dot)hp(dot)com>