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

Поиск
Список
Период
Сортировка

name vs text vs varchar

От
"mike"
Дата:
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?

Re: name vs text vs varchar

От
Bruce Momjian
Дата:
[ 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