{"id":56,"date":"2024-11-16T15:50:43","date_gmt":"2024-11-16T08:50:43","guid":{"rendered":"https:\/\/www.pgtutorial.com\/?page_id=56"},"modified":"2024-11-16T17:35:37","modified_gmt":"2024-11-16T10:35:37","slug":"what-is-postgresql","status":"publish","type":"page","link":"https:\/\/www.pgtutorial.com\/postgresql-tutorial\/what-is-postgresql\/","title":{"rendered":"What is PostgreSQL"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you’ll learn about PostgreSQL and what you can build with PostgreSQL.<\/p>\n\n\n\n

What is a database #<\/a><\/h2>\n\n\n\n

A database is a repository for storing information. It allows you to store data from various sources, such as external files and websites, and organize it in a structured manner.<\/p>\n\n\n\n

Typically, databases store data on hard drives, allowing for later retrieval or updates.<\/p>\n\n\n\n

What is PostgreSQL #<\/a><\/h2>\n\n\n\n

PostgreSQL, often referred to as Postgres<\/em>, is a free<\/em> and open-source<\/em> relational database management system (RDBMS):<\/p>\n\n\n

\n
\"what<\/figure>\n<\/div>\n\n\n

In RDBMS, data is organized into multiple related table tables. For example, you can have a table to store products and another table to store invoices.<\/p>\n\n\n\n

PostgreSQL is famous for its robustness, performance, and flexibility.<\/p>\n\n\n\n

PostgreSQL is utilized across applications, ranging from small-scale projects to large enterprise systems.<\/p>\n\n\n\n

PostgreSQL clients #<\/a><\/h2>\n\n\n\n

To work with PostgreSQL databases, you need a client program.<\/p>\n\n\n\n

There are many types of PostgreSQL client programs available:<\/p>\n\n\n\n