POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the CREATE TABLE statement in PostgreSQL?

What are the basic components you need to define when creating a table in PostgreSQL?

What is a primary key, and why is it important when creating a table in PostgreSQL?

How do you define a foreign key constraint when creating a table in PostgreSQL, and what is its purpose?

Explain the concept of a composite primary key in PostgreSQL and when it might be used.

What are some common constraints you can apply to columns when creating a table in PostgreSQL?

Describe how inheritance works when creating tables in PostgreSQL.

What is a tablespace in PostgreSQL, and how does it relate to table creation?

How can you use the PARTITION BY clause when creating a table in PostgreSQL, and what are its benefits?

Discuss the considerations and best practices for designing a table schema in PostgreSQL for optimal performance and scalability.