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 substring() with Regular ExpressionsHow to InsertHow 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 ColumnHow to Rename a ColumnHow 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 ConstraintHow to Create an IndexHow to Drop an IndexHow to Create a ViewHow to Drop a ViewHow to Alter Sequence
Dates and Times
Analysis
How to Use Lateral JoinsHow 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 CSVHow 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?
