4 ms·

99% of PostgreSQL reserved keywords are singular (except `references`), so if you use plural table names, you're more likely to avoid using a reserved keyword (

• alerighi 3y ago
  This. While naming tables with singular names is the formally correct choices, since the name must be seen as the name of the relation and not of a collection (that is the same name that in a programming language you would choose for a class), in practice there are too many common keywords that are singular, thus you have the choice of choosing plural and still have meaningful names, add a prefix/suffix to all tables, or remembering to quote every time you use a name. I prefer the first, since the second one adds inconvenience and the third one adds possibility of mistakes when you forget to quote it.
• Someone 3y ago
  > 99% of PostgreSQL reserved keywords are singular (except `references`) It can clash with the plural noun, but ‘References’ is a singular verb conjugation in PostgreSQL, isn’t it?
  • elchief 3y ago
    Can you make a table called `references`? No, you cannot
    • saltcured 3y ago
      CREATE TABLE "references" ("user" serial8 PRIMARY KEY, ... ); The further I get in my career, the more often I think it is a mistake when languages encourage the use of ambiguous syntax over safer alternatives.