SQL script to generate a calendar in postgres

postgres_calendar.sql

-- change :year to desired year. :variable is a php PDO binding thing
SELECT to_char(date_trunc('week', dd)::date - '1 day'::INTERVAL,'mm/dd/yy') AS sunday
     , to_char(date_trunc('week', dd)::date + '0 day'::INTERVAL,'mm/dd/yy') AS monday
     , to_char(date_trunc('week', dd)::date + '1 day'::INTERVAL,'mm/dd/yy') AS tuesday
     , to_char(date_trunc('week', dd)::date + '2 day'::INTERVAL,'mm/dd/yy') AS wednesday
     , to_char(date_trunc('week', dd)::date + '3 day'::INTERVAL,'mm/dd/yy') AS thursday
     , to_char(date_trunc('week', dd)::date + '4 day'::INTERVAL,'mm/dd/yy') AS friday
     , to_char(date_trunc('week', dd)::date + '5 day'::INTERVAL,'mm/dd/yy') AS saturday
FROM generate_series
				  (( '1/1/' ||  :year)::timestamp
        ,  ('12/31/' || :year)::timestamp
        , '7 day'::interval) dd
ORDER BY  date_trunc('week', dd)::date - '1 day'::INTERVAL;