State of Postgres support, and/or command line interface?

[Klaus Dahlke]

On Fri, 18 May 2007 10:54:56 -0400
Braindead <Braindead at diablops.com> wrote:

> I'm running 2.0.5 (under Gentoo, seems to be the latest in portage).
> 
> What I want to do is be able to either use the postgres backend permanently (last I read it's still not the preferred backend?) *or* be able to export my data into postgres.
> 
> What I'd like to accomplish with this is to create automated webpages with reports/status of budget for my household.  I can do this from the XML files if need be, but it'd be mighty nice to be able to query data from a database backend.
> 
> Just thought I'd see if there are any other suggestions.  
> 

Hi Braindead,
I have written two perl-scripts that converts gnucash's zipped xml-file into sql statements for parsing the date into the old gnucash-1.8.x table strucutre.
The first script is for initial load, the second just posts the delta between the last post to database and actual date. The date handling is not pretty sophistacted but sufficient for me. I still like to continue to do the reporting based on sql.

Cheers,
Klaus