PostgreSQL 9.3 : Generate months name list

Question

我想使用 PostgreSQL 9.3 生成月份名称列表。

例如:

Months
---------
January
February
March
April
..
..
December

Answer 1

select to_char(m, 'Month')
from generate_series(
    '2014-01-01'::date, '2014-12-31', '1 month'
) s(m);
  to_char  
-----------
 January  
 February 
 March    
 April    
 May      
 June     
 July     
 August   
 September
 October  
 November 
 December