import gnucash flat file into psql

Derek Atkins warlord at MIT.EDU
Mon Nov 3 23:06:23 CST 2003

File -> Save As

Give it your postgres URI as the filename


Mike G <mike at> writes:

> Hi,
> I have been using gnucash for a few months now storing all my financials
> in the gnucash flat file.
> I have always had postgres on my pc and would now like to use gnucash
> with it.
> I have successfully created the database and tables in postgresql.  
> I am now trying to import my current gnucash flat file into the database
> but cannot figure out how to do it.  
> I am using 1.8.7 and postgres 7.3.4.
> I have tried to import it using File->Import Qif and the other option
> file type(my current gnucash flat file).
> I have also tried to export the accounts so that they could possible be
> re-imported(nothing seems to be exported).
> Lastly I have opened the flat file in gnucash and then done a File->Save
> As using postgres://local... as the path.
> Is it not possible to convert a current flat file to postgres?
> Mike
> -- 
> Mike G <mike at>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at

       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL:    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available

More information about the gnucash-user mailing list