Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Sample database for PostgreSQL

I am looking for a sample database (schema+data) for PostgreSQL 9. Is there a repository somewhere for sample databases?

like image 707
H-H Avatar asked Mar 19 '11 17:03

H-H


People also ask

What database does PostgreSQL use?

Robust, reliable open source relational database PostgreSQL is an advanced, enterprise class open source relational database that supports both SQL (relational) and JSON (non-relational) querying.

What are sample databases?

The Sample Database is a small database that ships with Metabase so you can start asking questions and creating dashboards before you connect to your database. The Sample Database contains four tables: Orders , People , Products , and Reviews .

Can I create a database in Postgres?

CREATE DATABASE creates a new PostgreSQL database. To create a database, you must be a superuser or have the special CREATEDB privilege. See CREATE ROLE. By default, the new database will be created by cloning the standard system database template1 .

Does PostgreSQL have database?

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.


1 Answers

There's a PgFoundry project that contains several example PostgreSQL databases. Most of these haven't been updated for a while, but will still work with recent PostgreSQL versions.

If you need a bigger database, the MusicBrainz music metadata database has full database dumps available for download.

like image 57
intgr Avatar answered Sep 29 '22 06:09

intgr