POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the LENGTH function in PostgreSQL?

How do you use the UPPER function in PostgreSQL, and what does it do?

Can you explain the TRIM function in PostgreSQL and its typical use case?

What does the SUBSTRING function do in PostgreSQL, and how is it commonly used?

Explain the use of the CONCAT function in PostgreSQL.

What is the purpose of the REPLACE function in PostgreSQL, and how would you use it?

How does the REGEXP_REPLACE function differ from the REPLACE function in PostgreSQL?

Describe how you would use the SPLIT_PART function in PostgreSQL.

What is the FORMAT function in PostgreSQL, and why is it powerful?

How does the TO_CHAR function work in PostgreSQL when formatting numbers and dates as strings?