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

Leave a Comment

Your email address will not be published.

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