The money type stores a currency amount with a fixed fractional
precision; see Table 8-3. The fractional precision is determined
by the database's lc_monetary setting. The range shown in the
table assumes there are two fractional digits. Input is accepted
in a variety of formats, including integer and floating-point
literals, as well as typical currency formatting, such as
'$1,000.00'. Output is generally in the latter form but depends
on the locale. Table 8-3. Monetary Types |money||8
bytes||currency amount||-92233720368547758.08 to
+92233720368547758.07| Since the output of this data type is
locale-sensitive, it might not work to load money data into a
database that has a different setting of lc_monetary. To avoid
problems, before restoring a dump into a new database make sure
lc_monetary has the same or equivalent value as in the database
that was dumped. Values of the numeric, int, and bigint data
types can be cast to money. Conversion from the real and double
precision data types can be done by casting t