Re: [GENERAL] anyone have experience with using Talend ETL tool

Irina Connelly wrote: > Hi, > > I am looking around for an ETL tool to transfer data from one Postgres > database to another periodically. > I was wondering if anyone has used Talend's Open Studio or any other > ETL tools and wouldn't mind sharing their thoughts. > > Thanks, > Irina > I've been

Re: [GENERAL] PostgreSQL and MOLAP ?

Joe Conway wrote: > Kevin Kempter wrote: >> Anyone know of any MOLAP/MDDB/MDX Business Intelligence reporting >> solutions tahat work on top of PostgreSQL ? >> > > I haven't used it myself, but you could check out Mondrian: > http://sourceforge.net/projects/mondrian/ > > HTH > > Joe > And fo

Re: [GENERAL] Documenting a DB schema

Check http://www.postgresql.org/docs/8.3/interactive/sql-comment.html Cheers! Shahaf Abileah wrote: > I’m looking for a systematic way to document the schema for the database > behind our website (www.redfin.com ), so that > the developers using this database have a better

Re: [GENERAL] Trying to understand encoding.

Geez. My default terminal didn't support UNICODE. Shame on me :P Thanks! Douglas McNaught wrote: > On 2/15/08, Tomás Di Doménico <[EMAIL PROTECTED]> wrote: > >> Now I have the data into the UTF8 DB, and using graphical clients >> everything seems to be great. T

[GENERAL] Trying to understand encoding.

Greetings. I'm currently using 8.3, but I've been coping with this since previous versions. I'm trying to integrate some LATIN1 and some UTF8 DBs into a single UTF8 one. To avoid the "Invalid UNICODE character..." error, I used iconv to convert the LATIN1 dumps to UTF8. Now I have the data into