Postgres Pro
Downloads
Home   >   mailing lists

Thread: name vs text vs varchar

name vs text vs varchar

From
"mike"
Date:
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

From
Bruce Momjian
Date:
[ 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