Re: name vs text vs varchar - Mailing list pgsql-general

From Bruce Momjian
Subject Re: name vs text vs varchar
Date
Msg-id 200103051716.MAA12488@candle.pha.pa.us
Whole thread Raw
In response to name vs text vs varchar  ("mike" <matrix@quadrent.net>)
List pgsql-general
[ 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

pgsql-general by date:

Previous
From: Limin Liu
Date:
Subject: chinese_big5 for PgAccess
Next
From: Bruce Momjian
Date:
Subject: Re: chinese_big5 for PgAccess