select open change scope Open full search

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

Extensions / Data types

postpic

A PostgreSQL image type with SQL image-processing and metadata functions, backed by GraphicsMagick, plus import/export utilities.

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

Overview

Packagepostpic
Version0.9.1
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemapublic
Stars137
Latest commit2015-12-07
Latest release2010-03-24
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

bytea_exifPostgreSQL extension for EXIF data reading from bytea value of image and MIME type check
pg_phashCalculate Hamming distance between decimal-encoded perceptual image hashes
imgsmlrImage similarity with haar
pg_abrisAbris metadata extension that creates a meta schema with metadata tables, views, and helper functions.
tbase_gts_toolsTBase helpers for inspecting transaction global timestamps and heap-page tuple metadata.
elementsChemical elements and isotope metadata exposed as PostgreSQL enum types through pgrx.
pg_catalog_get_defsAdds PL/pgSQL functions that reconstruct CREATE TYPE definitions from pg_catalog metadata.
npmSchema and tables for tracking npm package metadata and daily download counts.