{"id":22062,"date":"2023-02-22T02:18:25","date_gmt":"2023-02-22T02:18:25","guid":{"rendered":"https:\/\/www.booksofall.com\/cn\/?post_type=product&p=22062"},"modified":"2023-02-22T02:19:34","modified_gmt":"2023-02-22T02:19:34","slug":"postgresql-notes-for-professionals","status":"publish","type":"product","link":"https:\/\/www.booksofall.com\/cn\/postgresql-notes-for-professionals\/","title":{"rendered":"PostgreSQL Notes for Professionals"},"content":{"rendered":"

PostgreSQL also known as\u00a0Postgres, is a\u00a0free and open-source<\/a>\u00a0relational database management system<\/a>\u00a0(RDBMS) emphasizing\u00a0extensibility<\/a>\u00a0and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the\u00a0Ingres<\/a>\u00a0database developed at the\u00a0University of California, Berkeley<\/a>.\u00a0In 1996, the project was renamed to PostgreSQL to reflect its support for\u00a0SQL<\/a>. After a review in 2007, the development team decided to keep the name PostgreSQL and the alias Postgres.<\/p>\n

PostgreSQL features transactions with Atomicity, Consistency, Isolation, Durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. It is the default database for macOS Server and is also available for Linux, FreeBSD, OpenBSD, and Windows.<\/p>\n","protected":false},"excerpt":{"rendered":"