Re: Separating Database By Dates

In the Douglas book (p144), he recommends using Schema for separating
financial data by years.

Would that work for your purpose?
Tom
kellert(at)ohsu(dot)edu
503-494-2442

On Feb 10, 2009, at 8:29 AM, Rich Shepard wrote:

>
> I use SQL-Ledger with postgres as the back end for my business.
> While I
> can close a year from an accounting perspective, all data remain in
> the
> tables. What I would like to do is clone the tables, and have a
> separate
> database for each year. This is apparently not feasible within SL,
> so I
> wonder if it's practical and worth doing from within postgres. If
> so, then
> I'll need to figure out how to configure SL to work with the current
> year's
> data, yet access prior years if that's necessary.
>
> Any thoughts or comments will be welcome.
>
> Rich
>
> --
> Richard B. Shepard, Ph.D. | Integrity
> Credibility
> Applied Ecosystem Services, Inc. | Innovation
> <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax:
> 503-667-8863
>
> --
> Sent via pdxpug mailing list (pdxpug(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pdxpug
>