PostgreSQL Sample Database
PostgreSQL sample database with step-by-step guide on how to import and use the data
This page contains various PostgreSQL sample data.
https://github.com/jOOQ/sakila/tree/main/postgres-sakila-db
https://github.com/devrimgunduz/pagila https://github.com/xzilla/pagila
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));
https://sourceforge.net/projects/osdldbt/files/dbt2/0.40/
https://github.com/credativ/omdb-postgresql
https://wiki.openstreetmap.org/wiki/Planet.osm
https://developer.ibm.com/exchanges/data/all/airline/ https://transtats.bts.gov/PREZIP/
https://developers.google.com/freebase https://freebase-easy.cs.uni-freiburg.de/dump/
http://www.sportsdb.org/sd/samples
http://wikidata.dbpedia.org/develop/datasets
https://ftp.ncbi.nih.gov/gene/DATA/
https://postgrespro.com/education/demodb
https://archive.org/details/stackexchange https://github.com/Networks-Learning/stackexchange-dump-to-postgres
https://github.com/MuseumofModernArt/collection
https://linux.dell.com/dvdstore/
https://www.postgresqltutorial.com/postgresql-getting-started/postgresql-sample-database/
https://www.becomingads.com/o/sample_db https://github.com/pthom/northwind_psql
https://github.com/lerocha/chinook-database/tree/master/ChinookDatabase/DataSources
https://github.com/yugabyte/yugabyte-db/tree/master/sample
https://pgexercises.com/dbfiles/clubdata.sql
https://musicbrainz.org/doc/MusicBrainz_Database/Download
https://github.com/catherinedevlin/opensourceshakespeare
https://github.com/raosaif/sample_postgresql_database
https://github.com/robconery/dvdrental
https://github.com/YashMotwani/Sakila-DVD-Rental-database-Analysis
https://github.com/h8/employees-database
Before using any of these databases, make sure to check the documentation and licensing terms to ensure compliance with any usage restrictions. Additionally