SELECT fields from table having some conditions I have two tables 
1. Named as t1
2. Named as t2

example of the tables are : 

t1 :



 id  name 
 1   one 
 2   two 
 3   three  



t2 :



 id  name 
 2   five 



I need to select all the data from the t1 table as well as from table t2 but I don't want to write data from table t1 which is updated 

I need a resulting table like this:



 id  name 
 1   one 
 2   five 
 3   three  



Please help me to solve this in postgres
The cleanest has to be:

SELECT T1.id
       COALESCE(t2.name, t1.name) as name
FROM t1
LEFT JOIN t2
     ON t1.id = t2.id