Get current week of the month and year

Get current week of the current year

select extract(week from date_trunc('month', current_date))

Get current week of the current month

select extract(week from current_date) - extract(week from date_trunc('month',current_date))+1