Postgres The First Experience (Pavel Luzanov, Egor Rogov, Igor Levshin) (Z-Library)

This short pamphlet provides an overview of PostgreSQL DBMS, covering the history of its development, the main features, and a product roadmap. I 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. Contents at a glance: • PostgreSQL — what is it all about? • What’s new in PostgreSQL 15 • 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