Howtodojo

PostgreSQL Sample Database

PostgreSQL Sample Database

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

Adventureworks for PostgreSQL

URL

Mouse Genome Sample Data

URL

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

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.

Prev
MySQL Sample Database