PostgreSQL is an open source computer database management system (DBMS). It was created by Michael Stonebraker, a professor of Computer Science at University of California, Berkeley. PostgreSQL is the world’s most advanced open source database.
The PostgreSQL Community is made up of users and developers from around the world who work together to create a robust and powerful open source database system. The PostgreSQL community is committed to providing fast, scalable, high-performance SQL databases.
PostgreSQL has been used in mission-critical operations for nearly three decades by many of the world’s largest organizations.
Sample Database For PostgreSQL
The postgresql sample databases are a set of example databases that come with PostgreSQL. They can be used for testing and demonstration purposes, but should not be used for production systems.
The dvdrental database is an example of a simple relational database for a DVD rental store. It has two tables: one for movies, and one for customers. Both tables have integer primary keys (ID), and the customer table has an additional integer foreign key (CustomerID) referencing the movie’s ID.
The dvdrental database comes with some sample data in order to populate the tables with data. However, it does not come with any customer data, so if you want to use this database you will need to add your own test data.
The PostgreSQL database is an object-relational database management system. Some of the features of PostgreSQL are:
PostgreSQL is a powerful and flexible database system, and it’s free. It’s used by high-profile companies like Facebook and Twitter, so it’s a good choice if you want to build something that can scale.
Sample Databases
The pgFoundry page lists several sample databases. You can also find additional examples on GitHub. Here are some that might be useful:
Dvdrental – A sample schema for a DVD rental store with catalogs and user accounts. This database was originally created by Michael Zuskin at PGCon 2010.
Postgres Open Data – A few tables from the United Kingdom’s Government Open Data portal (data.gov.uk). This includes demographics data from the 2011 census, transport timetables from Transport Direct, and more than 200 other datasets from various departments in the UK government (including health records).
PostgreSQL is an object-relational database management system that supports many of the advanced features of SQL.
PostgreSQL has been developed by the PostgreSQL Global Development Group (PGDG), a diverse group of many companies and individual contributors. It is free and open-source software.
This article provides a list of some interesting sample databases that are available for PostgreSQL. These sample databases can be used as reference to understand how to use PostgreSQL, or as a basis for creating new databases.
PostgreSQL is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards-compliance.
PostgreSQL consists of the server daemon (pg_server), which accepts connections from client programs, and a number of utilities for managing databases, tables, columns, indexes, users, documentation, etc. Together these provide complete support for traditional SQL queries as well as procedural languages and functions.
PostgreSQL is developed by PostgreSQL Global Development Group (PGDG), a community of individuals who contribute their time and effort to developing PostgreSQL. The PGDG has many thousands of members who are involved in all aspects of the project’s development.
PostgreSQL can be downloaded freely from http://www.postgresql.org/download/.
PostgreSQL is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards-compliance. It was created by Michael Stonebraker and now developed by the PostgreSQL Global Development Group, a worldwide group of volunteers employed and supervised by companies such as Red Hat and EnterpriseDB.
The PostgreSQL project includes the server itself, programming language bindings, command-line tools, libraries for several programming languages, extensions to add features not available in the standard distribution, and several documentation projects. This package provides the source for the PostgreSQL database server.
PostgreSQL v9.2 sample database https://github.com/pld-labs/postgresql-dvdrental
Sample PostgreSQL database online https://www.sqlite.org/cgi/tutorial?db=world&tree=main:world:world:database:world_public&view=default
Public Postgres database for testing https://www.postgresql.org/docs/9.6/static/sql-create-template1.html
The postgresql dvdrental sample database is a public database that you can use to test some SQL queries. It also includes some example tables and data, so you can learn how to write queries against it.
The dvdrental database is hosted on GitHub. You can download it using git clone, or you can view the repository online.
Here are some sample queries that you can run against the dvdrental database:
SELECT rental_id, title, rental_duration FROM rentals;
SELECT rental_id, title FROM rentals WHERE rental_duration > 100;
SELECT rental_id, title FROM rentals WHERE rental_duration = 100 AND (rating >= 3 OR rating <= 4);
This is the PostgreSQL database created from the SQL queries in this blog post.
If you want to download the data, please do so by clicking on the “Download” button on the right side of this page.
To import this into your own PostgreSQL instance, you can use the following SQL commands:
CREATE TABLE dvdrental (dvdrentalid integer NOT NULL PRIMARY KEY, title varchar(255) NOT NULL UNIQUE, rating smallint NOT NULL DEFAULT 0); rentaldate timestamp with time zone NOT NULL DEFAULT now(), duereturndate timestamp with time zone DEFAULT now() + interval ‘1 day’, status tinyint NOT NULL DEFAULT 0); INSERT INTO dvdrental (title , rating) VALUES (‘The Shawshank Redemption’, 7),(‘The Dark Knight’, 9),(‘The Godfather’, 10),(‘It’s a Wonderful Life’, 10),(‘Casablanca’, 8),(‘Saving Private Ryan’, 9),(‘The Lord of the Rings: The Fellowship of the Ring’, 8);
DVD Rental Database SQL Queries
The dvd rental database contains the following tables:
Movie. The movie table has two columns: title and release_date. The title column contains the name of the movie, and the release_date column contains the date that the movie was released.
Customer. The customer table has four columns: cust_id, first_name, last_name, and phone_number. The cust_id column contains an integer value that uniquely identifies each customer in our database. The first_name, last_name, and phone_number columns contain information about a customer’s name and phone number.
RentalHistory. The rentalhistory table contains information about what movies have been rented by each customer in our database. This table has three columns: cust_id, title, and rentaldate (which is a datetime data type). The cust_id column contains an integer value that uniquely identifies each customer in our database; this value corresponds to the same value used in our customers table to identify each customer. The title column contains an integer value that identifies which movie was rented by each customer; this value corresponds to the same value used in our movies table to identify each movie title available for rent