[Solved] Which of the following is the correct syntax to return all columns of updated rows in PostgreSQL? — Ans: UPDATE table_name SET col = val RETURNING *; | PostgreSQL

PostgreSQL - Set Operations and Advanced Queries

Which of the following is the correct syntax to return all columns of updated rows in PostgreSQL?

AUPDATE table_name SET col = val RETURNING ALL COLUMNS;

BUPDATE table_name SET col = val RETURNING *;

CUPDATE table_name SET col = val RETURNING ALL;

DUPDATE table_name SET col = val RETURN *;

Step-by-Step Solution

Solution:

Step 1: Recall correct RETURNING syntax
PostgreSQL uses RETURNING followed by column names or * to return all columns.
Step 2: Identify correct option
Only UPDATE table_name SET col = val RETURNING *; uses RETURNING * which is valid syntax to return all columns.
Final Answer:
UPDATE table_name SET col = val RETURNING *; -> Option B
Quick Check:
RETURNING * returns all columns [OK]

Quick Trick: Use RETURNING * to get all columns after update [OK]

Common Mistakes:

Master "Set Operations and Advanced Queries" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which of the following is the correct syntax to return all columns of updated rows in PostgreSQL?