There's more...

Some of the PostgreSQL-based services on the cloud will return the same value of version() as community PostgreSQL does. While this is correct, in the sense that they are indeed running that version of PostgreSQL, it doesn’t mean that you have the same level of control. For instance, you might not be given a superuser account, and you will probably be unable to install extensions freely.