
PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BS 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. Introduce yourself to PostgreSQL , and learn about its features and usage. The PostgreSQL docs are a great place to learn about Postgres, and the PostgreSQL Tutorial is the place to start. General introduction to PostgreSQL for beginners Postgres guide.
Covers fundamentals of setup, general SQL, backups, common tools, and Postgres specific tips. Summary: in this tutorial , we will show you how to install PostgreSQL on your local system for learning and practicing PostgreSQL. PostgreSQL was developed for UNIX-like platforms, however, it was designed to be portable. It means that PostgreSQL can also run on other platforms such as Mac OS X, Solaris, and Windows. First, you will learn how to query data from a single table using basic data selection techniques such as selecting columns, sorting result set, and filtering rows.
Then, you will learn about the advanced queries such as joining multiple tables, using set operations, and constructing the subquery. Windows installers Interactive installer by EnterpriseDB. A window function performs a calculation across a set of table rows that are somehow related to the current row.

