| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | excalibur(at)hub(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Table name lengths... |
| Date: | 2003-09-02 17:36:33 |
| Message-ID: | 20030902173633.GH21909@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-09-02 17:36:49 | Re: Table name lengths... |
| Previous Message | Chris Bowlby | 2003-09-02 17:33:00 | Re: Table name lengths... |