double-precision floating point number, 8-byte storage
arbitrary precision number
date and time
Figure shows queries using these types.
There is table creation, INSERT, and SELECT.
Example of common data types
There are a few things of interest in this example. First, notice how the numbers
did not require quotes, while character strings, dates, and times require them.
Also note the datetime column displays its value in the standard UNIX
date6.3 format. It also keeps track of the time zone. Finally, notice the last SELECT
query. When you select too much information to fit on one line, the display
wraps around, making it hard to read. The columns still line up, but there is
other data in the way. There is no good solution to this except selecting fewer
columns or using psql's expanded output option, \x,
which displays one field per line.6.4 You can select any columns from the table in any order.