Surprising features of postgres

Disclaimer: Not sure if they will surprise you

A role can be a user

This is STUPID ! It’s anti common sense.

utf8 charset supports 4-byte chars

In mysql you have to specify the charset to be “utf8mb4”, but in postgres it can just be “utf8”

When you create a new database, any role is allowed to create objects in the public schema of this database

This is crazy. You should revoke the creating permissions of other roles. See https://stackoverflow.com/questions/760210/how-do-you-create-a-read-only-user-in-postgresql/39029296#39029296

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.