| Lists: | pgsql-admin |
|---|
| From: | "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
|---|---|
| To: | "Pgsql-Admin (E-mail)" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Longest name for table/column/key/index |
| Date: | 2004-10-18 03:59:24 |
| Message-ID: | A3D1526C98B7C1409A687E0943EAC410489E9A@obelix.askesis.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
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(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
| Cc: | "Pgsql-Admin (E-mail)" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Longest name for table/column/key/index |
| Date: | 2004-10-18 04:08:21 |
| Message-ID: | 200410180408.i9I48LU01258@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073