Answer the question
In order to leave comments, you need to log in
Is it possible to name a table with a number?
It is convenient to use numbers for naming, but I do not know if it will work. Well, there’s no deployed base at hand to try
Answer the question
In order to leave comments, you need to log in
Most likely not, because identifiers always do not start with numbers. This is an old rule. It is already half a century old and it works not only in pg but also in Oracle and in many translator languages.
CREATE TABLE "12345"( Value char(10));
It's just a string of numbers. The number gives error 42601.
There is no deployed base at handRextester .
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question