POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is JSON in PostgreSQL, and why is it used?

How can you retrieve JSON data from a PostgreSQL table?

What are the differences between the JSON and JSONB data types in PostgreSQL?

How do you access a specific key in a JSON column in PostgreSQL?

Explain how to use the json_each function in PostgreSQL.

What is the purpose of the json_array_elements function in PostgreSQL?

Describe how to create an index on a JSONB column in PostgreSQL.

How can you query nested JSON objects in PostgreSQL?

What is the use of the jsonb_set function in PostgreSQL?

Explain how to use the jsonb_path_query function in PostgreSQL and its benefits.