Frequently used postgres commands used for, like setting up the database or restoring the database.
Conditional Unique Constraints in Postgres using Partial IndexesChaitanya Varma
Partial Indexes are a way to create indexing on a partial data set of a table which satisfies the given logic. when these combined with unique indexes it can helps in adding conditional unique constraints on a table. Conditional unique constraints can help in avoiding duplication of records becasue of various concurrent duplicate requests