User Tools

Site Tools


create_sql_file_for_chart_of_accounts

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

create_sql_file_for_chart_of_accounts [2016/08/21 19:44]
sweitmann created
create_sql_file_for_chart_of_accounts [2016/08/21 19:45] (current)
sweitmann
Line 53: Line 53:
  
 INSERT INTO curr (rn, curr, prec) VALUES (3,'​EUR',​2);​ INSERT INTO curr (rn, curr, prec) VALUES (3,'​EUR',​2);​
 +
 +
 +For gifi accounts you just need to run
 +
 +    pg_dump -U postgres --table=gifi --column-inserts ledger28 > gifi-chart.sql
 +
 +and then remove any unwanted text before first INSERT.
  
create_sql_file_for_chart_of_accounts.txt ยท Last modified: 2016/08/21 19:45 by sweitmann