[Solved] Which condition must be true for a view in PostgreSQL to be updatable? — Ans: The view must be based on a single table without any aggregate functions. | PostgreSQL

PostgreSQL - Views and Materialized Views

Which condition must be true for a view in PostgreSQL to be updatable?

AThe view must include at least one JOIN between tables.

BThe view must use GROUP BY clauses.

CThe view must be based on a single table without any aggregate functions.

DThe view must contain UNION statements.

Step-by-Step Solution

Solution:

Step 1: Understand updatable view basics
Updatable views in PostgreSQL require a simple structure, typically based on a single table without aggregates or joins.
Step 2: Analyze the options
Options A, C, and D include joins, grouping, or unions, which make views non-updatable by default.
Final Answer:
The view must be based on a single table without any aggregate functions. -> Option C
Quick Check:
Updatable view condition = single table, no aggregates [OK]

Quick Trick: Updatable views need simple single-table SELECTs [OK]

Common Mistakes:

Master "Views and Materialized Views" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which condition must be true for a view in PostgreSQL to be updatable?