Amazon Redhisft: Re-occurring date for public holiday table : I am trying to create a table for the public holiday for the countries we deal with. However, I want the dates to be re-occurring so that I can apply a date key for each.

For example, if I have 2018-06-16 and 2018-12-25 as a public holiday, then I want the table to auto-generate 2019-06-16 and 2018-12-25 and so on without me adding it manually each time.

Anyone knows how this can be done in amazon redshift?