Re: Table name lengths... - Mailing list pgsql-general

From Tom Lane
Subject Re: Table name lengths...
Date
Msg-id 22130.1062524840@sss.pgh.pa.us
Whole thread Raw
In response to Re: Table name lengths...  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: Table name lengths...  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Any way to Convince postgres to push join clause inside subquery aggregate?
Next
From: Tom Lane
Date:
Subject: Re: segfaults / backend crashing