Introduction to PostgreSQL
A high level overview of the PostgreSQL database
PostgreSQL, also called PostgreSQL, is one of the most popular SQL database management systems (DBMS) ever.
It is Open Source, free for personal and commercial use, and it has a long history that started in 1996, building on top of other software that dates back to the 1980’s.
PostgreSQL is a really complete and full-featured general purpose relational database.
It provides support for most of the SQL standard, and also builds on top of it its unique set of features, to provide us a great tool.
You can find the project homepage at https://www.postgresql.org.
We can interact with a PostgreSQL database using many different programming languages. Internally, being a relational database we’ll use SQL to insert, query and manipulate the data.
More PostgreSQL tutorials:
- How to install PostgreSQL
- PostgreSQL user permissions
- How to list all users in PostgreSQL
- How to list all databases using PostgreSQL
- How to switch database using PostgreSQL
- How to create a PostgreSQL database
I am going to write a lot of PostgreSQL tutorials in the near future. I will link them here.
download all my books for free
- javascript handbook
- typescript handbook
- css handbook
- node.js handbook
- astro handbook
- html handbook
- next.js pages router handbook
- alpine.js handbook
- htmx handbook
- react handbook
- sql handbook
- git cheat sheet
- laravel handbook
- express handbook
- swift handbook
- go handbook
- php handbook
- python handbook
- cli handbook
- c handbook
subscribe to my newsletter to get them
Terms: by subscribing to the newsletter you agree the following terms and conditions and privacy policy. The aim of the newsletter is to keep you up to date about new tutorials, new book releases or courses organized by Flavio. If you wish to unsubscribe from the newsletter, you can click the unsubscribe link that's present at the bottom of each email, anytime. I will not communicate/spread/publish or otherwise give away your address. Your email address is the only personal information collected, and it's only collected for the primary purpose of keeping you informed through the newsletter. It's stored in a secure server based in the EU. You can contact Flavio by emailing flavio@flaviocopes.com. These terms and conditions are governed by the laws in force in Italy and you unconditionally submit to the jurisdiction of the courts of Italy.