PostgreSQL Tutorial

PostgreSQL Tutorial

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.

PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows.

This tutorial will give you quick start with PostgreSQL and make you comfortable with PostgreSQL programming.


This reference has been prepared for the beginners to help them understand the basic to advanced concepts related to PostgreSQL Database.


Before you start doing practice with various types of examples given in this reference, I'm making an assumption that you are already aware about what is database, especially RDBMS and what is a computer programming language.

Compile/Execute PostgreSQL Programs

If you are willing to compile and execute SQL statements then you can use online utility, which is available on a high end dedciated server giving you real programming experience with a comfort of single click execution. Yes! it is absolutely free and its online.

1 - PostgreSQL Functions Reference

At Tutorials Point, you will find references on all important built-in PostgreSQL functions.

PostgreSQL Useful Functions

2 - PostgreSQL Useful Resources

A collection of PostgreSQL Database Sites and Books is given at this page.

PostgreSQL Useful Resources

3 - PostgreSQL Tutorial in PDF

Download a quick PostgreSQL tutorial in PDF format.

PostgreSQL Tutorial in PDF