Re: Sample database for testing?

From: Andy Ruhl <acruhl(at)sdf(dot)lonestar(dot)org>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: bangh <banghe(at)baileylink(dot)net>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Sample database for testing?
Date: 2002-02-01 23:01:38
Message-ID: Pine.NEB.4.33.0202012251250.9527-100000@sdf.lonestar.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 1 Feb 2002, Oliver Elphick wrote:

> If you do this, you will have mytable in every database you create
> thereafter. It is not called a template for no reason! template1 is
> copied in its entirety into every new database when it is created. (And
> so the rest of the advice is redundant, too.)

Yeah, I don't think I want to mess with template.

> A better choice is to run the regression tests and use the regression
> database for your experiments, since it will have a lot of tables
> already containing data.

I actually ordered the new Practical Postgresql book from O'Reilly. There
is a sample database in there called booktown.sql. I realize this book is
free online, but I like to support the cause...

> Isle of Wight http://www.lfix.co.uk/oliver

I gotta check this place out...

Andy

--
acruhl(at)sdf(dot)lonestar(dot)org
SDF Public Access UNIX System - http://sdf.lonestar.org

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Brett W. McCoy 2002-02-01 23:56:07 Re: SQL question
Previous Message Oliver Elphick 2002-02-01 21:19:03 Re: Sample database for testing?