POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the INSERT statement in PostgreSQL?

Can you insert data into all columns of a table without specifying column names?

What happens if you try to insert a value that exceeds the defined data type limit of a column?

How can you insert data into only some columns of a table while leaving others as NULL?

What is the RETURNING clause, and how is it useful in an INSERT statement?

What is the difference between inserting a single row and inserting multiple rows in PostgreSQL?

What is an UPSERT operation and how is it achieved in PostgreSQL?

How do you handle inserting rows with conflicts in PostgreSQL, such as unique constraint violations?

Describe how to use a CTE (Common Table Expression) with an INSERT statement.

In a transactional context, explain how INSERT statements behave with respect to transaction isolation levels.