POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is a row in PostgreSQL?

What is a column in PostgreSQL?

How do you define the columns of a table when creating it in PostgreSQL?

What are the different data types you can use for columns in PostgreSQL?

How can you add a new column to an existing table in PostgreSQL?

What is the difference between a primary key column and a unique column in PostgreSQL?

How can you retrieve metadata about the columns in a PostgreSQL table?

Explain how you can use constraints on columns in PostgreSQL and provide an example.

How can you optimize the performance of column retrieval in PostgreSQL?

What is the significance of columnar storage in PostgreSQL, and when should it be used?