PostgreSQL error utilities.
Works with both pg and @electric-sql/pglite — both set .code
on error objects using standard PostgreSQL error codes.
2 declarations
(error: unknown): boolean import {is_pg_unique_violation} from '@fuzdev/fuz_app/db/pg_error.js'; Check if an error is a PostgreSQL unique constraint violation (error code 23505).
errorthe caught error
unknownboolean true if the error is a unique constraint violation
(error: unknown): string | null import {pg_error_code} from '@fuzdev/fuz_app/db/pg_error.js'; Extract the error-code string from a caught error, for SQLSTATE checks.
Other error families also carry string codes (Node FS errors:
ENOENT, ENOSPC, …) — compare the result against specific SQLSTATE
values, never against truthiness.
errorthe caught error
unknownstring | null the code string, or null when the value isn't an Error
or carries no string code