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@sdf.lonestar.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@postgresql.org so that your
> message can get through to the mailing list cleanly