Postgres Error Codes

Postgres error codes mapping for NodeJS.

Install

npm i @fiveem/postgres-error-codes

Usage

Each condition from the PG documentation is available in the module. In order to obtain the status code use the prefixed uppercase condition name:

unique_violation => PG_UNIQUE_VIOLATION

not_null_violation => PG_NOT_NULL_VIOLATION

const { PG_UNIQUE_VIOLATION, PG_NOT_NULL_VIOLATION } = require('postgres-error-codes')

async function createUserMethod(req, res, next) {
    try {
        // Run insert user SQL
    } catch (err) {
        // If user with same email already exists
        if (err.code === PG_UNIQUE_VIOLATION) {
            return next('Email already exists!')
        }

        // Param should not be null
        if (err.code === PG_NOT_NULL_VIOLATION) {
            return next('Email required!')
        }

        next(err)
    }
}

Related

• PostgreSQL Error Codes Documentation