CREATE TABLE 15909434_user ( ... )

当然会产生错误.然后,在我试图用google进行一些研究之后,我发现一篇很好的文章@L_502_0@描述：

When you create an object in Postgresql,you give that object a name. Every table has a name,every column has a name,and so on. Postgresql uses a single data type to define all object names: the name type.

A value of type name is a string of 63 or fewer characters. A name must start with a letter or an underscore; the rest of the string can contain letters,digits,and underscores.

…

If you find that you need to create an object that does not meet these rules,you can enclose the name in double quotes. Wrapping a name in quotes creates a quoted identifier. For example,you could create a table whose name is “3.14159“—the double quotes are required,but are not actually a part of the name (that is,they are not stored and do not count against the 63-character limit). …

好的,现在我知道如何使用这个语法来解决这个问题(在表名上放置双引号)：

CREATE TABLE "15909434_user" ( ... )

您可以创建表或列名称,例如“15909434_user”和user_15909434,但是不能使用数字创建表或列名称,而不使用双引号.

那么,我很好奇,背后的原因(除了它是一个惯例).为什么这个惯例应用？是避免语法限制或其他原因吗？

提前感谢您的关注！