PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
When you are upserting a row (PostgreSQL >= 9.5), and you want the possible INSERT to be exactly the same as the possible … Read more
postgresql-9.5
Postgresql – unable to drop database because of some auto connections to DB
Whenever I try to drop database I get: ERROR: database “pilot” is being accessed by other users DETAIL: There is 1 other session … Read more