pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Longest name for table/column/key/index
2+ messages / 2 participants
[nested] [flat]

* Longest name for table/column/key/index
@ 2004-10-18 03:59 Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
  2004-10-18 04:08 ` Re: Longest name for table/column/key/index Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Joost Kraaijeveld @ 2004-10-18 03:59 UTC (permalink / raw)
  To: 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.Kraaijeveld@Askesis.nl
web: www.askesis.nl 



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Longest name for table/column/key/index
  2004-10-18 03:59 Longest name for table/column/key/index Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
@ 2004-10-18 04:08 ` Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 2004-10-18 04:08 UTC (permalink / raw)
  To: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>; +Cc: 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@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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-10-18 04:08 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-18 03:59 Longest name for table/column/key/index Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2004-10-18 04:08 ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox