PostgreSQL
Basics
How to Compare ArraysHow to Concatenate StringsHow to Convert the Case of a StringHow to Create an ArrayHow to Insert Data Into an ArrayHow to Modify ArraysHow to Query ArraysHow to Replace SubstringsHow to Trim StringsHow to Use string_agg()How to Use substring()How to Use PostgreSQL substring() with RegEx to Extract a StringHow to Insert Into PostgreSQLHow to UpdateHow to Delete
Database Management
How to Create a TableHow to Drop a TableHow to Rename a TableHow to Truncate a TableHow to Duplicate a TableHow to Add a ColumnHow to Drop a ColumnPostgreSQL: Change a Column NameHow to Add a Default Value to a ColumnHow to Remove a Default Value From a ColumnHow to Add a Not Null ConstraintHow to Remove a Not Null ConstraintPostgreSQL: Add an IndexHow to Drop an IndexHow to Create a ViewHow to Drop a ViewPostgreSQL: Reset Sequence Command
Dates and Times
Analysis
How to Use nullif()How to Use Lateral JoinsHow to Calculate PercentilesHow to Get the First Row per GroupHow to Use generate_series to Avoid Gaps In DataHow to Do Type CastingHow to Write a Common Table ExpressionHow to Import a CSV into PostgreSQL using CopyHow to Compare Two Values When One Is NullHow to Use CoalesceHow to Write a Case StatementHow to Query a JSON ColumnHow to Use Filter to Have Multiple CountsHow to Calculate Cumulative Sum-Running Total
Ready for a modern SQL editor?
