J'ai:
wejustdb=> select id, username, mood_id from user_app;
 id  | username | mood_id 
-----+----------+---------
 239 | username |     236
 250 | username |     247
 261 | username |     258
 272 | username |     269
 278 | lol      |     280
 287 | alexx    |        
 286 | alex     |     295
 282 | a        |     304
 306 | b        | 


wejustdb=> select mood from mood;
     mood      
---------------
 (126,4,125)
 (128,4,127)
 (130,4,129)
 (132,4,131)
 (135,4,134)
 (138,4,137)
 (155,153,154)
 (184,182,183)
 (195,193,194)
 (210,4,209)
 (214,212,213)
 (225,223,224)
 (236,234,235)
 (247,245,246)
 (258,256,257)
 (269,267,268)
 (280,4,279)
 (289,4,288)
 (292,4,291)
 (295,2,294)
 (301,4,300)
 (304,4,303)
(22 rows)


wejustdb=> select * from mood_save;
 id  |        last_use         | mood_id | user_id | order_mood 
-----+-------------------------+---------+---------+------------
 281 | 2017-03-22 14:10:16.952 |     280 |     278 |          0
 290 | 2017-03-23 09:38:12.397 |     289 |     286 |          0
 293 | 2017-03-23 09:38:42.011 |     292 |     286 |          0
 296 | 2017-03-23 09:48:04.08  |     295 |     286 |          0
 302 | 2017-03-27 15:50:31.04  |     301 |     282 |          0
 305 | 2017-03-27 15:52:11.633 |     304 |     282 |          0
(6 rows)


Et je demande /mood/4/1