Other Data Types
The following are various data types that are used less frequently. Often, these are used for internal system purposes only, but you might run across them, so they are listed here for completeness.
BIT and BIT VARYING
The BIT type stores a series of binary-1 and binary-0 values. The BIT data type has a specified width and pads empty entries with zeros, whereas the BIT VARYING data type allows flexible-width entries to be made.
MONEY
The MONEY data type is still supported but is no longer considered active. Consider using a NUMERIC or DECIMAL data type with an appropriately set decimal width.
NAME
The NAME data type stores a 31-character string, but it is only intended to be used internally. PostgreSQL makes use of the NAME ...
Get PostgreSQL Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
