Re: Sample database for testing?

From: bangh <banghe(at)baileylink(dot)net>
To: Andy Ruhl <acruhl(at)sdf(dot)lonestar(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Sample database for testing?
Date: 2002-02-01 20:26:57
Message-ID: 3C5AFA10.B0B664FC@baileylink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

There is a database template1 you can play with.

If there is no table in template1, you can create one by:

psql template1
psql> create table mytable (
psql> mydate datetime,
psql> mymem text);
psql> insert into mytable values('now', 'I am doing this today');
psql> select * from mytable;
psql>\q;

dump your database:

pg_dump template1 > mydump.pgdump

create another copy of this database:

createdb newdatabase

cat mydump.pgdump | psql newdatabase

have a look at your new database

psql newdatabase
psql>\d;
psql>select * from mytable;
(add a new column)
psql>alter table mytable add column priority text;
psql>insert into mytable values('now', 'Always play at first, then ...',
'super high');
psql>select * from mytable;
psql>\q;

Have a lot of fun!

Banghe

Andy Ruhl wrote:

> I'm new to postgresql and I was wondering if there was a "sample" database
> out there I could use to practice dumping and reloading. I figure I should
> get good at recovery and administration before I actually use it... I
> don't have a database to do these kinds of things with and I'd rather not
> write one just so I can hose it...
>
> Thanks.
>
> Andy
>
> acruhl(at)sdf(dot)lonestar(dot)org
> SDF Public Access UNIX System - http://sdf.lonestar.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2002-02-01 20:27:27 Re: Urgent help neede - Important - Tks
Previous Message Stephan Szabo 2002-02-01 19:38:47 Re: SQL question