dbTalk Databases Forums  

Sample database schema and data

comp.databases.postgresql comp.databases.postgresql


Discuss Sample database schema and data in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Swati F
 
Posts: n/a

Default Sample database schema and data - 03-12-2009 , 09:23 PM






Hi I am looking for sample database in postgres, i.e a sample schema
and data for say a library database. I need a schema to be of medium
complexity with at least 100 tables and on an avg 500 rows in each
table. I need this to simulate a real time database systems.

Could anyone suggest how could I get this going? Oracle comes with
some sample databases, but i did not find something of this sort for
postgres.

Thanks,
Swati

Reply With Quote
  #2  
Old   
Thomas Kellerer
 
Posts: n/a

Default Re: Sample database schema and data - 03-13-2009 , 01:30 AM






Swati F, 13.03.2009 04:23:
Quote:
Hi I am looking for sample database in postgres, i.e a sample schema
and data for say a library database. I need a schema to be of medium
complexity with at least 100 tables and on an avg 500 rows in each
table. I need this to simulate a real time database systems.

Could anyone suggest how could I get this going? Oracle comes with
some sample databases, but i did not find something of this sort for
postgres.

Thanks,
Swati
Look at this one:

http://pgfoundry.org/projects/dbsamples/

I don't think it has that many tables. But it definitely has more than 500 rows.

Thomas


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.