Postgresql Concepts for MySQL Users

Postgres’ UPSERT functionality is an important improvement. Although most developers think of it as a syntax improvement, it’s much deeper than that:

  1. the developer can do new and different things in one statement
  2. duplicate key log messages can be easily suppressed
  3. upsert is atomic, whereas insert/exist/select is not atomic without locking effort

Uniqueness in PostgreSQL: Constraints versus Indexes
Avoid naming a constraint directly when using ON CONFLICT DO UPDATE
PostgreSQL Upsert Using INSERT ON CONFLICT statement
How to install PostgreSQL 9.5 on CentOS 7

Alias for table name in SQL insert statement
Postgres 9.5 feature highlight – Upsert
psql: FATAL: database “” does not exist
psql: FATAL: Ident authentication failed for user “username” Error and Solution
Postgresql Repos: 9.5, 9.6
Postgresql Sample Databases
Postgres.app
brew install postgresql@9.6

This entry was posted in Open Source, Postgresql, Tech. Bookmark the permalink.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.