Skip to content
Example Database for PostgreSQL : World DB
Branch: master
Clone or download
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
scripts FIX #1 : Add country_fk (city.country_code -> country.code) Jun 22, 2017
.dockerignore
.gitattributes Force EOL = LF for docker-healthcheck (shell script) Aug 13, 2018
.gitignore
.travis.yml
ALTERNATIVES.md Documentation : comment on Sakila May 16, 2017
CHANGELOG.md FIX #4 : Upgrade to PostgreSQL 11 Oct 19, 2018
Dockerfile FIX #4 : Upgrade to PostgreSQL 11 Oct 19, 2018
README.md FIX #4 : Upgrade to PostgreSQL 11 Oct 19, 2018
docker-healthcheck

README.md

postgres-world-db

Build Status Docker Pulls GitHub tag

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 camel 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 -pxxxx:5432 ghusta/postgres-world-db:2.3

Alternatives

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

You can’t perform that action at this time.