How to postgres

PostgreSQL features summary and tips.

Feel free to contribute with issues and PRs. This guide is directly inspired by, and regularly refers to, the official documentation.

Summary

• Architecture
• Installation
• Basics :
  • Users and databases
  • Accessing database
  • Table creation
  • Inserting data in table
  • Querying your tables
  • Updating table data
  • Delete table data
  • Aggregates
• Constraints and indexes
  • Indexes
  • Constraints

TODOS :

• Constraints and indexes
• Joins
• Advanced queries
• Views
• Usefully data types
• Techniques
  • Window functions
  • Analyse query planning
  • Full text search
  • Materialised views
  • Performance tuning
  • Partitioning