PostgreSQLRunbook 0/2 done
42703

PostgreSQL Error 42703: Undefined column

Error✕ Not retryable · fix the payloadHTTP 400 Bad RequestDatabase
TL;DR · 10-second read

The column name does not exist on that relation. Usually a camelCase column created with quotes; reference it as "createdAt" or rename it to snake_case.

Identify: does your log match?

What you see · exact log / response
ERROR:  column "createdat" does not exist
LINE 1: SELECT id, createdAt FROM orders;
                   ^
HINT:  Perhaps you meant to reference the column "orders.createdAt".

Fix

Being written

Copy-paste fixes for 42703 are in the enrichment queue

The summary above is verified. Paste your full trace into the decoder for a diagnosis now.

Open the decoder →

Related errors

Last verified 2026-10-14 · Source: Official Appendix A error codes (errcodes.txt in the postgres repo) · Official docs ↗ · ~8,100 searches/mo