Contents

• Overview of PostgreSQL →

• Installing PostgreSQL →

• Connecting to PostgreSQL – Basics →

• Creating and Managing Cluster with pg wrappers (Ubuntu only) →

• Creating and Managing Cluster with native commands →

• Creating and Managing Databases →

• Creating and Managing Users/Roles →

• Restricting Role access to Databases →

• Connecting to PostgreSQL – Advanced →

• Connecting from psql in different ways →

• Connecting using Passfile →

• Connecting using Service File →

• Connecting using Environment Variables →

• In-depth with psql →

• Data Types in PostgreSQL →

• Casting of Data Types →

• Date Time Operations →

• Creating Schemas →

• Creating Tables →

• Creating Views →

• Creating Functions →

• Creating Procedures →

• Creating Trigger Functions →

• Viewing Metadata →

• Extracting DDL of Objects →

• Backing up and Restoring the PostgreSQL Cluster →

• Architecture of PostgreSQL →