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 or whole thread)
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-2015 The PostgreSQL Global Development Group