Postgres: The First Experience (original) (raw)

Your first guide to the galaxy of Postgres

This short pamphlet provides an overview of PostgreSQL DBMS, covering the history of its development, the main features, and a product roadmap. If you are just getting started, you can use this book as a step-by-step installation and configuration guide.

We hope it will make your first experience with PostgreSQL more pleasant and help you blend into the PostgreSQL community.

Download in PDF

A printed version of this book is often available for free at conferences where Prosgres Professional is participating.

Contents at a glance:

• PostgreSQL — what is it all about?
• What’s new in PostgreSQL 17
• Installation on Linux and Windows
• Connecting to a server, writing SQL queries, and using transactions
• Learning the SQL language on a demo database
• Using PostgreSQL with your application
• Minimal server setup
• About a useful pgAdmin application
• Advanced features: full-text search, JSON format, and foreign data wrappers
• Education and certification opportunities
• Keeping up with all updates
• About the Postgres Professional company