In this article, we would like to show you how to
DROP VIEW IF EXISTS in PostgreSQL.
DROP VIEW IF EXISTS "view_name";
To show how the
DROP VIEW IF EXISTS statement works, we will use the following table:
At the end of this article you can find database preparation SQL queries.
In this example, we will delete the
Spain Users view which we created in this article.
DROP VIEW IF EXISTS "Spain Users";
If you try to drop a view that already exists with
DROP VIEW query you will get an error:
But if you try to
DROP VIEW IF EXISTS you will get a warning instead:
CREATE TABLE "users" ( "id" SERIAL PRIMARY KEY, "name" VARCHAR(100) NOT NULL, "email" VARCHAR(100) NOT NULL, "country" VARCHAR(15) NOT NULL );
INSERT INTO "users" ("name", "email", "country") VALUES ('Tom', 'email@example.com', 'Poland'), ('Chris','firstname.lastname@example.org', 'Spain'), ('Jack','email@example.com', 'Spain'), ('Kim','firstname.lastname@example.org', 'Vietnam'), ('Marco','email@example.com', 'Italy'), ('Kate','firstname.lastname@example.org', 'Spain'), ('Nam','email@example.com', 'Vietnam');