postgresql datatype
table:common data types in postgresql
| character string |
char(length) |
blank-padded string, fixed storage length |
| |
varchar(length) |
variable storage length |
| number |
integer |
integer, +/-2 billion range |
| |
float |
floating point number, 15-digit precision |
| |
numeric (precision, decimal) |
number with user-defined precision and decimal |
| |
|
location |
| date/time |
date |
date |
| |
time |
time |
| |
timestamp |
date and time |
if put this in the table header, it will be escpased by jekyll. very strange
<tr>
<td align="center" colspan=1>category</td>
<td align="center" colspan=1>type</td>
<td align="center" colspan=1>description</td>
</tr>