postgres-world-db

Example Database for PostgreSQL : World DB

Database script downloaded at : http://pgfoundry.org/frs/?group_id=1000150&release_id=366#world-world-1.0-title-content

See also PostgreSQL Sample Databases.

Database details

Important note : from version 2.0, tables and columns names use snake case. This version is incompatible with version 1.x.

Default parameters

• database : world-db
• user : world
• password : world123

Schema

• public

Tables

This database contains 3 tables :

• city
• country
• country_language

Relationships

• country_language -> country (country_language_country_code_fkey)
• country -> city (country_capital_fkey)

Docker

You can launch this docker image like this :

docker run -d -p xxxx:5432 ghusta/postgres-world-db:2.5

Alternatives

You can find alternative DBMS or databases examples at this page.