[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: clone database with no financial transactions



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;

Best Wishes,
Chris Travers