PostgreSQL Sample Database

PostgreSQL sample database with step-by-step guide on how to impor and use the data

Introduction

This page contains various PostgreSQL sample data.

jOOQ postgresql-sakila-db

https://github.com/jOOQ/sakila/tree/main/postgres-sakila-db

Pagila

https://github.com/devrimgunduz/pagila https://github.com/xzilla/pagila

Price Paid Data from HM Land Registry

https://www.gov.uk/government/statistical-data-sets/price-paid-data-downloads#single-file

Download the csv file using the command below:

wget -c http://prod.publicdata.landregistry.gov.uk.s3-website-eu-west-1.amazonaws.com/pp-complete.csv

Login to PostgreSQL installation. Use the query below to create the table

-- Create table:
CREATE TABLE land_registry_price_paid_uk(
  transaction uuid,
  price numeric,
  transfer_date date,
  postcode text,
  property_type char(1),
  newly_built boolean,
  duration char(1),
  paon text,
  saon text,
  street text,
  locality text,
  city text,
  district text,
  county text,
  ppd_category_type char(1),
  record_status char(1));

Import the data to PostgreSQL

-- Copy CSV data, with appropriate munging:
COPY land_registry_price_paid_uk FROM 'pp-complete.csv' with (format csv, encoding 'win1252', header false, null '', quote '"', force_null (postcode, saon, paon, street, locality, city, district));

pgFoundry data samples

https://www.postgresql.org/ftp/projects/pgFoundry/dbsamples/ https://github.com/morenoh149/postgresDBSamples

Adventureworks for PostgreSQL

https://github.com/lorint/AdventureWorks-for-Postgres

Mouse Genome Sample Data

http://www.informatics.jax.org/downloads/database_backups/ http://www.informatics.jax.org/software.shtml

DBT-2

https://sourceforge.net/projects/osdldbt/files/dbt2/0.40/

IMDB Datasets

https://datasets.imdbws.com/

OMDB PostgreSQL

https://github.com/credativ/omdb-postgresql

OpenStreetMap

https://wiki.openstreetmap.org/wiki/Planet.osm

US Bureau of Transportation Statistics - Reporting Carrier On-Time Performance

https://developer.ibm.com/exchanges/data/all/airline/ https://transtats.bts.gov/PREZIP/

Freebase

https://developers.google.com/freebase https://freebase-easy.cs.uni-freiburg.de/dump/

SportsDB

http://www.sportsdb.org/sd/samples

DBPedia

http://wikidata.dbpedia.org/develop/datasets

biological annotation from NCBI’s ENTREZ system

https://ftp.ncbi.nih.gov/gene/DATA/

Postgrespro DemoDB

https://postgrespro.com/education/demodb

StackExchange Data Dump

https://archive.org/details/stackexchange https://github.com/Networks-Learning/stackexchange-dump-to-postgres

The Museum of Modern Art (MoMA) Collection

https://github.com/MuseumofModernArt/collection

Dell DVD Store Database Test Suite

https://linux.dell.com/dvdstore/

Postgresqltutorial Sample Database

https://www.postgresqltutorial.com/postgresql-getting-started/postgresql-sample-database/

Northwind Sample Database

https://www.becomingads.com/o/sample_db https://github.com/pthom/northwind_psql

Chinook Database

https://github.com/lerocha/chinook-database/tree/master/ChinookDatabase/DataSources

Yugabyte Data Sample

https://github.com/yugabyte/yugabyte-db/tree/master/sample

Pgexercises Data Sample

https://pgexercises.com/dbfiles/clubdata.sql

Musicbrainz Database Download

https://musicbrainz.org/doc/MusicBrainz_Database/Download

Open Source Shakespeare PostgreSQL

https://github.com/catherinedevlin/opensourceshakespeare

Sample PostgreSQL Database by raosaif

https://github.com/raosaif/sample_postgresql_database

dvdrental

https://github.com/robconery/dvdrental

Sakila DVD Rental Database Analysis

https://github.com/YashMotwani/Sakila-DVD-Rental-database-Analysis

Employees Database in PostgreSQL

https://github.com/h8/employees-database

PostgreSQL Samples Databases by Azure

https://github.com/Azure-Samples/postgresql-samples-databases