POSTGRESQL DATABASE INTERVIEW QUESTIONS

What are the basic data types available in PostgreSQL?

What is the difference between CHAR and VARCHAR data types in PostgreSQL?

How does PostgreSQL handle boolean data types?

Can you explain the use of SERIAL data type in PostgreSQL?

What are the array data types in PostgreSQL and how are they useful?

Describe the JSON and JSONB data types in PostgreSQL.

What is the UUID data type in PostgreSQL and when should you use it?

Explain the HSTORE data type and its typical use cases in PostgreSQL.

What are composite types in PostgreSQL and how are they created and used?

Discuss the performance implications of using different data types in PostgreSQL.