Chris Travers wrote: > On Mon, Jun 27, 2011 at 11:02 PM, Chris Travers <[email protected]> > wrote: >> On Mon, Jun 27, 2011 at 10:02 PM, david <[email protected]> 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.
Ahh.. that's the bit I was looking for. Do I do that with psql? ------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
