2 ms·
A few reasons: - Transactional DDL statements (schema modifications) - Better support for UPSERT operations - Better JSON support (including ability to index
by nicoburns 3y ago
A few reasons:
- Transactional DDL statements (schema modifications)
- Better support for UPSERT operations
- Better JSON support (including ability to index into JSON columns)
- the RETURNING statement to return data that was inserted/updated
In general Postgres is a lot more featureful than MySQL.