How to replace null value to other value in postgresql...

How to replace null value to other value in postgresql

postgresql have a function to replace null to any other value
The function name is COALESCE(column_name,'replacement text')

example:
select COALESCE(name,'No Name Found') from people_list_table