Lesser-known Postgres features
I want to stress the importance of not using  id int SERIAL

If you are on a somewhat recent version of postgres, please do yourself a favor and use:  id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY

An "identity column", the part here:https://hakibenita.com/postgresql-unknown-features#prevent-s...You might think this is trivial -- but SERIAL creates an "owned" (by a certain user) sequence behind the scenes, and so you run into massive headaches if you try to move things around.Identity columns don't, and avoid the issue altogether.https://www.2ndquadrant.com/en/blog/postgresql-10-identity-c...