PostgreSQL - find row with null value in column

In this article, we would like to show you how to find rows with NULL value in one of the columns in PostgreSQL.

Quick solution:

SELECT *
FROM "table_name" 
WHERE "column_name" IS NULL;

Sometimes your data can be an empty string. You can select such rows with the below query:

SELECT FROM "table_name" WHERE "column_name" = '';

Practical example

To show how to find rows with NULL value in one of the columns, we will use the following table:

Note:

At the end of this article you can find database preparation SQL queries.

Example

In this example, we will select rows from users table with NULL value in email column.

Query:

SELECT * 
FROM "users"
WHERE "email" IS NULL;

Result:

Database preparation

create_tables.sql file:

CREATE TABLE "users" (
	"id" SERIAL,
	"name" VARCHAR(50) NOT NULL,
	"surname" VARCHAR(50) NOT NULL,
	"email" VARCHAR(50),
	PRIMARY KEY ("id")
);

insert_data.sql file:

INSERT INTO "users"
	( "name", "surname", "email")
VALUES
	('John', 'Stewart', 'john@email.com'),
	('Chris', 'Brown', NULL),
	('Kate', 'Lewis', NULL),
	('Ailisa', 'Gomez', 'ailisa@email.com'),
	('Gwendolyn', 'James', NULL),
	('Simon', 'Collins', NULL),
	('Taylor', 'Martin', NULL),
	('Andrew', 'Thompson', 'andrew@email.com');

Related posts

• PostgreSQL - find row with null value in one of many columns

• PostgreSQL - search for NULL values in multiple columns