PostgreSQL Error 42P01 - Undefined Table

What It Means

PostgreSQL error code 42P01 (undefined_table) means the query references a table (or view) that does not exist. The error message typically reads: relation "table_name" does not exist. This is PostgreSQL’s equivalent of MySQL error 1146.

Common Causes

• Database migrations have not been run
• Typo in the table name
• Table is in a different schema (e.g., public vs app)
• Case sensitivity: unquoted names are lowercased by PostgreSQL
• Query references a table in the wrong database
• Table was dropped or never created
• Using a different database than expected

How to Fix

Check existing tables

-- List all tables in the public schema
\dt

-- List tables in all schemas
\dt *.*

-- Search for a specific table
SELECT table_schema, table_name
FROM information_schema.tables
WHERE table_name LIKE '%user%';

-- Check current database and schema
SELECT current_database(), current_schema();

Fix schema issues

-- Table might be in a different schema
SELECT * FROM public.users;       -- Explicit schema
SELECT * FROM app.users;          -- Different schema

-- Set the search path to include your schema
SET search_path TO app, public;

-- Or permanently in postgresql.conf
-- search_path = '"$user", public, app'

Fix case sensitivity

-- PostgreSQL lowercases unquoted identifiers
CREATE TABLE "MyTable" (id INT);  -- Stored as "MyTable"

-- Must use quotes to reference it
SELECT * FROM "MyTable";     -- Works
SELECT * FROM MyTable;       -- Error! Looks for "mytable"
SELECT * FROM mytable;       -- Error! Same thing

-- Best practice: use lowercase names without quotes
CREATE TABLE my_table (id INT);
SELECT * FROM my_table;  -- Always works

Run migrations

# Django
python manage.py migrate

# Rails
rails db:migrate

# Node.js Prisma
npx prisma migrate deploy

# Node.js Knex
npx knex migrate:latest

# Alembic (Python)
alembic upgrade head

Create the table

CREATE TABLE IF NOT EXISTS users (
    id SERIAL PRIMARY KEY,
    email VARCHAR(255) UNIQUE NOT NULL,
    name VARCHAR(255) NOT NULL,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
    updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

Handle in application code

// Node.js - catch the error
try {
  const result = await pool.query('SELECT * FROM users');
} catch (error) {
  if (error.code === '42P01') {
    console.error(`Table does not exist: ${error.message}`);
    // Run migrations or create the table
  }
}

# Python
import psycopg2

try:
    cursor.execute("SELECT * FROM users")
except psycopg2.errors.UndefinedTable:
    conn.rollback()
    print("Table 'users' does not exist. Run migrations.")

Related Errors

• PostgreSQL 42601 - Syntax error: The SQL syntax itself is invalid.
• PostgreSQL 23505 - Unique violation: Table exists but has a constraint issue.
• MySQL 1146 - Table doesn’t exist: The MySQL equivalent.