# Postgres error 42703: column "x" does not exist

> A query names a column the table does not have.

Source: https://scribase.com/postgres-errors/42703

SQLSTATE class: Syntax Error or Access Rule Violation. Over PostgREST/supabase-js this maps to HTTP 400.

## Causes

- A typo, or camelCase in code against snake_case columns.
- A string literal written with double quotes ("active") instead of single quotes, so Postgres reads it as a column name.
- The migration adding the column has not run here.

## Fixes

- Use single quotes for strings.
- Check the columns with \d table.
- Run pending migrations on this database.

In supabase-js, a select string with a column that does not exist gives this error; PostgREST answers 400.