11
22 Frequently Asked Questions (FAQ) for PostgreSQL
33
4- Last updated: Sun Jan 1209:58:38 EST 2003
4+ Last updated: Sun Jan 1213:36:11 EST 2003
55
66 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
77
820820
821821Type Internal Name Notes
822822--------------------------------------------------
823- "char" char 1 character
824- CHAR(n) bpchar blank padded to the specified fixed length
825823VARCHAR(n) varchar size specifies maximum length, no padding
824+ CHAR(n) bpchar blank padded to the specified fixed length
826825TEXT text no specific upper limit on length
826+ "char" char one character
827827BYTEA bytea variable-length byte array (null-byte safe)
828828
829829 You will see the internal name when examining system catalogs and in
@@ -834,9 +834,9 @@ BYTEA bytea variable-length byte array (null-byte safe)
834834 space used is slightly greater than the declared size. However, these
835835 data types are also subject to compression or being stored out-of-line
836836 by TOAST, so the space on disk might also be less than expected.
837- VARCHAR(n) is best when storing variable-length stringsbut it limits
837+ VARCHAR(n) is best when storing variable-length stringsand it limits
838838 how long a string can be. TEXT is for strings of unlimited length,
839- maximum1 gigabyte.
839+ with a maximumof one gigabyte.
840840
841841 CHAR(n) is for storing strings that are all the same length. CHAR(n)
842842 pads with blanks to the specified length, while VARCHAR(n) only stores