Re: Table name lengths...

Ron Johnson <ron.l.johnson@cox.net> writes:
> No matter how long PostgreSQL lets you make table names, I'd stick
> with ANSI standard 31 characters.

"ANSI standard"?  SQL92 specifies that names can be up to 128 characters
long.  Perhaps there was a shorter limit in SQL89, but that ranks as
ancient history now.

(In fact, I just now realized that it says *characters*, not *bytes*,
which means that in a multibyte encoding you could need quite a bit more
than 128 bytes to meet the spec's requirement...)

            regards, tom lane