Introducing PopSQL + dbt. The first SQL editor with built-in dbt supportRead more →

PostgreSQL

Basics

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 Modify Arrays How to Query Arrays How to Replace Substrings How to Trim Strings How to Use string_agg()How to Use substring()How to Use substring() with Regular Expressions How to Insert How to Update How to Delete

Database Management

How to Create a Table How 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 Drop a Column How to Rename a Column How to Add a Default Value to a Column 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 Create an Index How to Drop an Index How to Create a View How to Drop a View How to Alter Sequence

Dates and Times

How to Exclude Current or Partial Weeks How 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 Lateral Joins 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 How to Compare Two Values When One Is Null How to Use Coalesce How to Write a Case Statement How to Query a JSON Column How to Use Filter to Have Multiple Counts How to Calculate Cumulative Sum-Running Total

Ready for a modern SQL editor?

Get started for free

Cta