Skip site navigation (1) Skip section navigation (2)

NAME maximum length in _bytes_

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
Subject: NAME maximum length in _bytes_
Date: 2012-05-08 21:13:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docs
psql \dTS+ shows for data type 'name':

	 pg_catalog | name                | name            | 64   |          | 
        | 63-character type for storing system identifiers

I believe this is really 63 bytes, not characters.  I also see it
mismatched in our docs:

    in the internal system catalogs and is not intended for use by the general user. Its
    length is currently defined as 64 bytes (63 usable characters plus
    terminator) but should be referenced using the constant
    <symbol>NAMEDATALEN</symbol> in <literal>C</> source code.

Should I fix this?

  Bruce Momjian  <bruce(at)momjian(dot)us>

  + It's impossible for everything to be true. +


pgsql-docs by date

Next:From: Peter EisentrautDate: 2012-05-10 18:00:37
Subject: Re: Capitalization of 'TimeZone' GUC
Previous:From: Peter EisentrautDate: 2012-05-08 16:36:23
Subject: Re: misspellings & typofixes

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group