% CREATE EXTENSION tinyint; CREATE EXTENSION % SELECT 1::tinyint;
This module provides 1 byte signed integer type with operators, index access methods and support functions. You can use it as like the corresponding data type in other RDBMS as well as smallint, integer or bigint in PostgreSQL. Although the byte used for 1 tinyint is exactly 1 byte, you need to take account into its position in the row if you really care the table size since PostgreSQL usually pads extra bytes for the alignment of 4.
tinyint holds -127 to 127. +, -, *, %. min(), max(), sum(), avg(), btree index and gin index are supported as other integer types.
Copyright and License
Copyright (c) Hitoshi Harada.
This module is free software; you can redistribute it and/or modify it under the PostgreSQL License.
Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.