PostgreSQL
PostgreSQL, Powered for Insights: Learn with DataReportive.
This tutorial walks you through PostgreSQL from basics to advanced reporting. Discover how to structure, query, and optimize your data to fuel smarter dashboards, reports, and analytics—directly aligned with real-world use cases from the DataReportive platform.
Basics
How to InsertHow to Update
How to Delete
How to Trim Strings
How to Use substring()
How to Use substring() with RegEx to Extract a String
How to Replace Substrings
How to Modify Arrays
How to Compare Arrays
How to Concatenate Strings
How to Convert the Case of a String
How to Create an Array
How to Insert Data Into an Array
How to Query Arrays
How to Use string_agg()
Database Management
How to Create a TableHow to Drop a Table
How to Rename a Table
How to Truncate a Table
How to Duplicate a Table
How to Add a Column
How to Change a Column Name
How to Add a Default Value
How to Remove a Default Value From a Column
How to Add a Not Null Constraint
How to Remove a Not Null Constraint
How to Add an Index
How to Drop an Index
How to Create a View
How to Drop a View
How to Reset Sequence
How to Drop a Column
Dates and Times
How to Exclude Current or Partial WeeksHow to Use BETWEEN Correctly
How to Query Date and Time
How to Group by Time
How to Round Timestamps
How to Convert UTC to Local Time Zone
Analysis
How to Use nullif()How to Use Lateral Joins
How to Calculate Percentiles
How to Get the First Row per Group
How to Use generate_series to Avoid Gaps in Data
How to Do Type Casting
How to Write a Common Table Expression
How to Import a CSV using Copy
How to Compare Two Values When One Is Null
How to Use Coalesce
How to Write a Case Statement
How to Use Filter to Have Multiple Counts
How to Calculate Cumulative Sum-Running Total
How to Query a JSON Column