Обсуждение: name vs text vs varchar

[ Charset ISO-8859-1 unsupported, converting... ]
> reading through the curent development docs, I've run accross
> a data type called "name", and it looks very similar to varchar
> or text, and I'm wondering if there is any atvantage to useing
> this data type over varchar or even text?

It is used for system catalogs.  No reason for users to use it.  It is
fixed length 31 or NAMEDATALEN-1, and has no 4-byte length header like
the other text/varchar/char types.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026