On Mon, Jun 27, 2011 at 11:02 PM, Chris Travers <..hidden..> wrote:
On Mon, Jun 27, 2011 at 10:02 PM, david <..hidden..> wrote:
I want to clone a database but with no financial transactions. I want to
keep customers, vendors, parts, services, accounts, etc. but all
accounts with zero balance.
Is this possible?
Yes. In psql:
CREATE DATABASE my_newdb WITH TEMPLATE my_old_db;
Note this will clone everything.
If you want to get rid of the transactions, you will need to delete
everything in the acc_trans, ar, ap, and gl tables.