generate_series() failed in Redshift

Question

I worked well in DBeaver with code

INSERT INTO table_dates(calendar_date, day_of_week)
SELECT 
    generate_series::date as calendar_date,
    To_Char(generate_series, 'Dy') as. day_of_week
FROM generate_series(to_timestamp('1990-01-01 00:00:00','yyyy/mm/dd'), to_timestamp('2050-12-31 00:00:00' ,'yyyy/mm/dd') ,'1 day')

But I got error when I worked in Redshift, it looks like Redshift is not supported

generate_series()
Error: function generate_series(timestamp with time zone, timestamp with time zone, "unknown") does not exist
Hint: No function matches the given name and argument types. You may need to add explicit type casts.

I expect the result look like:

calendar_date  calendar_date  
1990-01-01  Mon
1990-01-02  Tue
1990-01-03  Wed
1990-01-04  Thu
1990-01-05  Fri
1990-01-06  Sat
1990-01-07  Sun
1990-01-08  Mon
1990-01-09  Tue
1990-01-10  Wed
1990-01-11  Thu
1990-01-12  Fri
1990-01-13  Sat
...
2050-12-31  Sat
```