1 files changed, 16 insertions, 0 deletions
diff --git a/backend/src/utils/dbErrorCheck.ts b/backend/src/utils/dbErrorCheck.ts
new file mode 100644
index 0000000..c5c6415
--- /dev/null
+++ b/backend/src/utils/dbErrorCheck.ts
@@ -0,0 +1,16 @@
+import type { PostgresError } from "../types/database.js";
+
+export function isPostgresError(error: unknown): error is PostgresError {
+    return (
+        error instanceof Error &&
+        "code" in error &&
+        typeof (error as PostgresError).code === "string"
+    );
+}
+
+export const PostgresErrorCodes = {
+    UNIQUE_VIOLATION: "23505",
+    FOREIGN_KEY_VIOLATION: "23503",
+    NOT_NULL_VIOLATION: "23502",
+    CHECK_VIOLATION: "23514",
+};