POSTGRESQL DATABASE INTERVIEW QUESTIONS

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

How do you add a new column to an existing table in PostgreSQL using the ALTER TABLE statement?

What happens if you try to drop a column from a PostgreSQL table that is part of a constraint?

How can you change the data type of a column in PostgreSQL using the ALTER TABLE statement?

Explain how to rename a table in PostgreSQL using the ALTER TABLE statement.

What is the effect of using the ALTER TABLE statement to add a NOT NULL constraint to an existing column in PostgreSQL?

How can you add a new foreign key constraint to an existing column in PostgreSQL using the ALTER TABLE statement?

Describe how to modify an existing column to have a default value in PostgreSQL using the ALTER TABLE statement.

What is the process of splitting a PostgreSQL table by adding table inheritance using the ALTER TABLE statement?

Discuss the impact of using the ALTER TABLE statement to convert a table to a partitioned table in PostgreSQL.