[Solved] What is the primary use of the hstore extension in PostgreSQL? — Ans: To store sets of key-value pairs within a single PostgreSQL value | PostgreSQL

PostgreSQL - Advanced Features

What is the primary use of the hstore extension in PostgreSQL?

ATo create materialized views automatically

BTo generate universally unique identifiers (UUIDs)

CTo perform fast text search using trigram matching

DTo store sets of key-value pairs within a single PostgreSQL value

Step-by-Step Solution

Solution:

Step 1: Understand the purpose of hstore
The hstore extension allows storing key-value pairs in a single column, useful for semi-structured data.
Step 2: Compare with other extensions
uuid-ossp generates UUIDs, pg_trgm helps with trigram text search, and materialized views are unrelated.
Final Answer:
To store sets of key-value pairs within a single PostgreSQL value -> Option D
Quick Check:
hstore purpose = key-value storage [OK]

Quick Trick: hstore = key-value pairs storage in one column [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is the primary use of the hstore extension in PostgreSQL?