select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Data types

tinyint

One-byte signed integer type with arithmetic, casts, aggregates, and B-tree, hash, and GIN operator classes.

pgext.cloud · Source code · Website · Documentation · Control file

Overview

Packagetinyint-postgresql
Version0.1.1
PostgreSQL versions10
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars28
Latest commit2017-11-07
Latest release2011-04-22
Catalogue updated2026-08-30

Related extensions

Required by

pg_variant_functionsVariant summary and allele-frequency functions over TINYINT[] genotype arrays

See also

ksjJapanese kanji-numeral integer type with arithmetic, aggregates, casts, comparison, and B-tree indexing
uuid47UUIDv7 storage with keyed UUIDv4-looking façade I/O
spanC data type for indexed document text spans, with casts, comparisons, B-tree/hash operator classes, aggregates, and accessors.
vercompDeprecated semantic-version data type and comparison operators
parray_ginGIN index operator class and partial-match operators for text arrays
utinyintOne-byte unsigned integer type with casts to smallint, integer, and boolean.
device_typeFixed-byte enum-like data type for mobile device types with comparison operators and btree/hash operator classes.
salesforce_idCompact 12-byte PostgreSQL type with casts, comparison operators, and B-tree/hash operator classes for Salesforce IDs.