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; Best Wishes, Chris Travers ------------------------------------------------------------------------------ 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
