Upsert(Insert/Update) statement in PostgreSQL
Insert statement ON CONFLICT (columns) DO NOTHING; References
Insert statement ON CONFLICT (columns) DO NOTHING; References
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