Обсуждение: Longest name for table/column/key/index

Hi all,

Are there any limits to the length of the names of tables, columns, primary keys and indexes in PostgreSQL?

Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl

Joost Kraaijeveld wrote:
> Hi all,
>
> Are there any limits to the length of the names of tables, columns, primary keys and indexes in PostgreSQL?

63 characters by default.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073