How to get day of week in Redshift database

Below is the query to return day of week from Redshift database. It returns a numeric output . 1 for Monday, 2 for Tuesday , and so on

select extract(dow from now());

See also  How to move table from one schema to another in Redshift