How to Use LIMIT in Postgres Delete in two roundabout ways
Postgres is a very popular and feature-rich database. However, unlike other database management systems like MySQL, you cannot use the LIMIT
keyword in Delete or Update statements. You can only use it in a select statement. In this blog post, you will learn about a couple of workarounds that can help delete rows on a Posgrest table with an arbitrary limit, let’s get going!