[Solved] What is the main purpose of using CREATE VIEW in PostgreSQL? — Ans: To save a SELECT query as a virtual table for easy reuse | PostgreSQL

PostgreSQL - Views and Materialized Views

What is the main purpose of using CREATE VIEW in PostgreSQL?

ATo delete rows from a table

BTo save a SELECT query as a virtual table for easy reuse

CTo permanently store data in a new table

DTo create an index on a table column

Step-by-Step Solution

Solution:

Step 1: Understand what a view is
A view is a virtual table that stores a SELECT query, not actual data.
Step 2: Identify the purpose of CREATE VIEW
CREATE VIEW saves the SELECT query so you can reuse it easily without rewriting it.
Final Answer:
To save a SELECT query as a virtual table for easy reuse -> Option B
Quick Check:
CREATE VIEW = virtual table for queries [OK]

Quick Trick: Views save SELECT queries as virtual tables [OK]

Common Mistakes:

Master "Views and Materialized Views" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is the main purpose of using CREATE VIEW in PostgreSQL?