Compatibility with PostgreSQL Amazon Redshift is based on PostgreSQL 8.0.2. To see differences between standard PostgreSQL and Redshift, click here.