PostgreSQL Sample Database

PostgreSQL sample database with step-by-step guide on how to import 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  

URL  

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

Adventureworks for PostgreSQL  

URL  

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

Mouse Genome Sample Data  

URL  

• 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

Before using any of these databases, make sure to check the documentation and licensing terms to ensure compliance with any usage restrictions. Additionally ensure you run the import on a test database.