Longest name for table/column/key/index

[Joost Kraaijeveld]

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: [phone]
fax: [phone]
e-mail: ***@Askesis.nl
web: www.askesis.nl

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

[Bruce Momjian]

Post by Joost Kraaijeveld
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
***@candle.pha.pa.us | [phone]
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org