Upsert(Insert/Update) statement in PostgreSQL
Insert statement ON CONFLICT (columns) DO NOTHING; References
[SQL] Remove duplicate records
Here’s an example of deleting records in postgresql
How to create a read-only user in Postgresql
This is a note of how to create a read-only user in Postgresql database. First, connect to the database by super user. Run this command to create an user and assign read-only to that user Example Example of revoke and drop users Revoke and drop users