Comment on Amazon Redshift - What You Need To KnowComments−superails12yRedshift smelled enough like PostgreSQLI'm curious. How does something smell like Postgres? Does it use some of the same PG-specific datatypes?−kungfooeyOP12yIt uses similar data types and has a similar API. The differences between the two are summarized in the documentation.http://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and...−tmarthal12yNot only does it use the same datatypes, but I know that it uses the same pg wire format such that the java (and I'm sure python) postgres drivers work out of the box.
Comments
I'm curious. How does something smell like Postgres? Does it use some of the same PG-specific datatypes?
It uses similar data types and has a similar API. The differences between the two are summarized in the documentation.
http://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and...
Not only does it use the same datatypes, but I know that it uses the same pg wire format such that the java (and I'm sure python) postgres drivers work out of the box.