PostgreSQL Error 42703: Undefined Column

PostgreSQL error 42703 (Undefined Column) explained: what it means, why it happens, and how to fix it — with copy-paste code examples.

SQLSTATE 42703 PostgreSQL Last verified 2026-08-19

Quick Answer

Inspect columns with \d table or information_schema.columns. If that does not apply, apply migrations that add the expected column — the full checklist is below.

Error Code

SQLSTATE: 42703
Official name: Undefined Column
Service: PostgreSQL

What does this error mean?

The referenced column does not exist in the table.

Common Causes

How to Fix

  1. Inspect columns with \d table or information_schema.columns
  2. Apply migrations that add the expected column
  3. Match quoting: unquoted identifiers fold to lowercase, quoted ones are exact
  4. Qualify columns in multi-table queries to resolve ambiguity

Code Examples

List columns of a table sql 
SELECT column_name, data_type
FROM information_schema.columns
WHERE table_name = 'orders'
ORDER BY ordinal_position;

Confirm exact column names and types before referencing them, especially after schema changes.

Framework-Specific Fixes

django

Verify the field name on the model and that makemigrations/migrate ran.

# ensure field exists and migration applied
class Order(models.Model):
    status = models.CharField(max_length=20)
sqlalchemy

Confirm the mapped Column name; use Column('real_name') if DB differs.

status = Column('status', String(20))

You Might Also Like

42P01 Undefined Table The referenced table does not exist in the current schema search path. 42883 Undefined Function The referenced function does not exist, or no function matches the given argument types. MySQL1054 Unknown Column Unknown column '%s' in '%s'

Frequently Asked Questions

Why am I seeing PostgreSQL error 42703?

Most often this happens when misspelling a column name, or when referencing a column not yet added by a pending migration.

How do I fix PostgreSQL error 42703?

Inspect columns with \d table or information_schema.columns.

Which frameworks have documented fixes for error 42703?

This page documents fixes for: django, sqlalchemy.

Official Sources

This page is based on the official PostgreSQL documentation linked below and adds practical troubleshooting guidance on top.