Bird
0
0

Which PostgreSQL function can be used to convert a text string into JSON format when inserting?

easy📝 Conceptual Q2 of 15
PostgreSQL - JSON and JSONB
Which PostgreSQL function can be used to convert a text string into JSON format when inserting?
Ato_json()
Bjson_parse()
Cjsonb_to_text()
Dcast_to_json()
Step-by-Step Solution
Solution:

  1. Step 1: Identify PostgreSQL JSON conversion functions

    PostgreSQL provides to_json() to convert various data types into JSON format.

  2. Step 2: Verify function correctness

    Functions like json_parse(), jsonb_to_text(), and cast_to_json() do not exist in PostgreSQL.

  3. Final Answer:

    to_json() -> Option A

  4. Quick Check:

    Convert text to JSON = to_json() [OK]
Quick Trick: Use to_json() to convert text or values to JSON format [OK]
Common Mistakes:
  • Using non-existent functions
  • Confusing jsonb and json functions
  • Trying to cast text directly without function

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More PostgreSQL Quizzes
Common Table Expressions - Recursive CTE for graph traversal - Quiz 3easy Common Table Expressions - WITH clause syntax - Quiz 2easy Full-Text Search - Highlighting with ts_headline - Quiz 11easy JSON and JSONB - JSONB existence (?) operator - Quiz 8hard Joins in PostgreSQL - LATERAL join for correlated subqueries - Quiz 3easy Subqueries in PostgreSQL - Correlated subqueries execution model - Quiz 6medium Views and Materialized Views - Why views matter in PostgreSQL - Quiz 14medium Views and Materialized Views - CREATE MATERIALIZED VIEW - Quiz 13medium Views and Materialized Views - Why views matter in PostgreSQL - Quiz 7medium Window Functions in PostgreSQL - Practical window function patterns - Quiz 15hard