PostgreSQL Lessons

Content

• Installation and Setup
• Data types
• Json, JsonB, Array Types
• Built in function
• Schema and Namespace
• Functions and Procedures
• Conditional Statement and Loops

Installation and Setup

I am using pgsql:16 docker image for this lesson. A docker compose file is given to create the pgsql container. Run the following command to crete the container.

docker compose up -d

I am using Datagrip by Jetbrains to run sql queries