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] – created sweitmanncreate_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