Horton

Re: index and sequence name length limit?

Neil Conway <nconway@klamath.dyndns.org>

View thread View on postgr.es
From: Neil Conway <nconway@klamath.dyndns.org>
To: Jean-Christian Imbeault <jc@mega-bucks.co.jp>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2002-08-05T07:44:20Z
Lists: pgsql-general 
Jean-Christian Imbeault <jc@mega-bucks.co.jp> writes:
> What is the limit on the length of a index or sequence's name?

31 by default, but you can increase that by changing the value of
NAMEDATALEN in src/include/pg_config.h, re-compiling, and re-running
initdb.

Cheers,

Neil

-- 
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC