PostgreSQL How-To Guides

Practical PostgreSQL answers with statements you can copy and run.

• How to Rename a Table in PostgreSQL
• How to Add a Column in PostgreSQL
• How to Rename a Column in PostgreSQL
• How to Drop a Column in PostgreSQL
• How to Insert Data in PostgreSQL
• How to Update Rows in PostgreSQL
• How to Delete Rows in PostgreSQL
• How to Create a View in PostgreSQL
• How to Duplicate a Table in PostgreSQL
• How to List Tables in PostgreSQL
• How to Truncate a Table in PostgreSQL
• How to Change a Column Type in PostgreSQL
• How to Upsert in PostgreSQL (INSERT ... ON CONFLICT)
• How to Generate a Date Series in PostgreSQL
• How to Kill a Running Query in PostgreSQL
• How to Create an Index in PostgreSQL
• How to List Indexes in PostgreSQL
• How to Add a Primary Key in PostgreSQL
• How to Add a Foreign Key in PostgreSQL
• How to Find Duplicate Rows in PostgreSQL
• How to Remove Duplicates in PostgreSQL
• How to Format Dates in PostgreSQL
• How to Calculate Date Differences in PostgreSQL
• How to Use string_agg in PostgreSQL
• How to Query JSON in PostgreSQL
• How to Create a Database in PostgreSQL
• How to List Databases in PostgreSQL
• How to Show a Table Schema in PostgreSQL
• How to Use COALESCE in PostgreSQL
• How to Vacuum a Table in PostgreSQL

Running PostgreSQL queries as a team? See the SaturnSQL PostgreSQL editor.