Features
Pricing
Docs
Learn SQL
Blog
Contact
Sign In
Download
PostgreSQL
Basics
How to Insert in PostgreSQL
How to Update in PostgreSQL
How to Delete in PostgreSQL
Database Management
How to Create a Table in PostgreSQL
How to Drop a Table in PostgreSQL
How to Rename a Table in PostgreSQL
How to Truncate a Table in PostgreSQL
How to Duplicate a Table in PostgreSQL
How to Add a Column in PostgreSQL
How to Drop a Column in PostgreSQL
How to Rename a Column in PostgreSQL
How to Add a Default Value to a Column in PostgreSQL
How to Remove a Default Value From a Column in PostgreSQL
How to Add a Not Null Constraint in PostgreSQL
How to Remove a Not Null Constraint in PostgreSQL
How to Create an Index in PostgreSQL
How to Drop an Index in PostgreSQL
How to Create a View in PostgreSQL
How to Drop a View in PostgreSQL
How to Alter Sequence in PostgreSQL
Dates and Times
How to Query Date and Time in PostgreSQL
How to Group by Time in PostgreSQL
How to Round Timestamps in PostgreSQL
How to Convert UTC to Local Time Zone in PostgreSQL
Analysis
How to Calculate Percentiles in PostgreSQL
How to Get the First Row per Group in PostgreSQL
How to Use generate_series to Avoid Gaps In Data in PostgreSQL
How to Do Type Casting in PostgreSQL
How to Write a Common Table Expression in PostgreSQL
How to Import a CSV in PostgreSQL
How to Compare Two Values When One Is Null in PostgreSQL
How to Use Coalesce in PostgreSQL
How to Write a Case Statement in PostgreSQL
How to Query a JSON Column in PostgreSQL
How to Use Filter to Have Multiple Counts in PostgreSQL
How to Calculate Cumulative Sum/Running Total in PostgreSQL
PopSQL is a modern SQL editor for teams.
Try it free today!
Learn SQL
/
PostgreSQL
/
How to Drop an Index in PostgreSQL
How to Drop an Index in PostgreSQL
drop
index
index_created_at_on_users
;
How to Create an Index in PostgreSQL
How to Create a View in PostgreSQL