AWS RedShift uses a subset of Postgre behind the scenes. Of course, it's missing a lot of the big pieces because RedShift is designed for an entirely different purpose than what most people are accustomed to. This is NOT a normal RDBMS Engine.
https://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html