[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: clone database with no financial transactions
- Subject: Re: clone database with no financial transactions
- From: Chris Travers <..hidden..>
- Date: Mon, 27 Jun 2011 23:02:18 -0700
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