Re: Table name lengths... - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Table name lengths...
Date
Msg-id 20030902173633.GH21909@dcc.uchile.cl
Whole thread Raw
In response to Re: Table name lengths...  (Richard Huxton <dev@archonet.com>)
List pgsql-general
On Tue, Sep 02, 2003 at 06:24:55PM +0100, Richard Huxton wrote:
> On Tuesday 02 September 2003 17:55, Chris Bowlby wrote:

> >  I've noticed that in the pg_type system table, there is a data type
> > called "name", would that represent the definition of the table name
> > space, including the max length a talbe name space could be? If so where
> > would I find the same definition for the max name space for a sequence,
> > or index...
>
> All names are the same length. This is 64 characters, but I _think_ it can be
> changed with a recompile.

63 characters IIRC (the 64th is used for a trailing \0, I think).

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The first of April is the day we remember what we are
the other 364 days of the year"  (Mark Twain)

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Table name lengths...
Next
From: Chris Bowlby
Date:
Subject: Re: Table name lengths...