Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
197 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| iso_codes | 0.1.0 | ISO country code enum/data types for PostgreSQL, generated with pgrx. | TYPE | GPL-3.0 | Rust | 13–17 | 10 |
| media_types | 0.1.0 | Strongly typed MIME media-type data type for PostgreSQL | TYPE | GPL-3.0 | Rust | 13–17 | 10 |
| molecular_formulas | 0.1.0 | Molecular-formula parser and strongly typed PostgreSQL data type | TYPE | GPL-3.0 | Rust | 13–17 | 10 |
| pg_thrift | 1.0 | Encode, decode, and query Apache Thrift binary and compact protocol values in PostgreSQL. | TYPE | — | C | 10–11 | 10 |
| pgsql_rrule | 0.0.4 | Pure SQL PostgreSQL data types and functions for parsing and expanding RFC 5545 recurrence rules. | TYPE | PostgreSQL | SQL | 10–18 | 10 |
| country | 0.0.3 | Country data type, ISO 3166-1 | TYPE | PostgreSQL | C | 14–18 | 9 |
| datalink | 0.5.0 | SQL/MED DATALINK data type and functions for controlled access to files outside PostgreSQL | TYPE | PostgreSQL | C | 10–18 | 9 |
| md5hash | 1.0.1 | type for storing 128-bit binary data inline | TYPE | BSD-2-Clause | C | 14–18 | 9 |
| plid | 0.0.0 | A 128-bit, lexicographically sortable PostgreSQL PLID type with short prefixes, millisecond timestamps, randomness, and optional monotonic generation. | TYPE | MIT | Rust | 13–18 | 8 |
| telephone | 0.0.1 | PostgreSQL data type for normalized telephone numbers with dialing-plan validation. | TYPE | PostgreSQL | C | 10–18 | 8 |
| cbor | 0.1.0 | Concise Binary Object Representation data type for PostgreSQL. | TYPE | PostgreSQL | C | 10–18 | 7 |
| hashtypes | 0.1.5 | sha1, md5 and other data types for PostgreSQL | TYPE | PostgreSQL | C | 14–18 | 7 |
| intpair | 0.2 | Packed int64pair data type with comparison, hash, and index operator support. | TYPE | Apache-2.0 | C | — | 7 |
| jansson-json | 0.0.2 | JSON data type, operators, and functions backed by the Jansson JSON library. | TYPE | MIT | C | 10–18 | 7 |
| pg-json | 0.0.1 | A json data type and related functions | TYPE | MIT | C | — | 7 |
| pg_text_semver | 1.2.1 | Semantic version domain and comparison operators for PostgreSQL | TYPE | PostgreSQL | SQL | 14–18 | 7 |
| pgbrtypes | 1.0 | Brazilian CPF and CNPJ data types with validation, formatting, casts, and indexing support | TYPE | — | C | 10–18 | 7 |
| postbis | 1.0 | Adds compressed DNA, RNA, amino-acid, and aligned sequence types with casts, operators, indexes, and bioinformatics functions. | TYPE | PostgreSQL | C | 14–18 | 7 |
| uints | 0.9 | C extension providing unsigned 16-bit and 32-bit integer types with casts, operators, and numeric support functions. | TYPE | PostgreSQL | C | — | 7 |
| ajbool | 0.0.3 | Three-valued boolean type with a pseudo-NULL unknown state for primary keys. | TYPE | PostgreSQL | C | 10–16 | 6 |
| 0.1 | Email address data type with validation, equality operators, and user/domain helper functions. | TYPE | PostgreSQL | C | 10–18 | 6 | |
| g_cube | 1.0 | GPU version of contrib/cube | TYPE | — | C | — | 6 |
| pg_datatype_password | 0.0.1 | SQL-only password data type and operators using pgcrypto Blowfish hashes, with trigger-based encryption before storage. | TYPE | MIT | SQL | 10–18 | 6 |
| pg_semver | 0.0.1 | Version(SEMVER) data type for postgresql | TYPE | MIT | C | — | 6 |
| postcode | 1.3.0 | Store UK postcodes in a compact 32-bit type with validation, formatting, partial matching, and B-tree indexing | TYPE | BSD-2-Clause | C | — | 6 |
| jsonb_schema | 1.0 | jsonb with separately stored schema | TYPE | PostgreSQL | C | — | 5 |
| variant | 1.0.1 | Variant data type that can store values from other PostgreSQL types. | TYPE | BSD-2-Clause | C | — | 5 |
| device_type | 0.0.2 | Fixed-byte enum-like data type for mobile device types with comparison operators and btree/hash operator classes. | TYPE | PostgreSQL | C | 10–18 | 4 |
| kmea | 1.0 | K-Mer Extension for Analysis | TYPE | MIT | C | — | 4 |
| lpathtree | 1.0 | Hierarchical path types using slash-separated labels | TYPE | — | C | — | 4 |
| number | 1 | Variable-width integer data type for PostgreSQL | TYPE | MIT | C | — | 4 |
| numhstore | 0.1.7 | Adds inthstore and floathstore numeric hstore types and helpers | TYPE | MIT | C | — | 4 |
| pg_fraction | 1.0 | Adds a fraction data type with arithmetic, comparison, aggregate and B-tree operator-class support. | TYPE | — | C | — | 4 |
| pgsfti | 1.0 | PostgreSQL data type for simple trapezoidal fuzzy time intervals and fuzzy temporal relations. | TYPE | MIT | C | — | 4 |
| postgreth | 0.0.1 | A pgrx extension providing Ethereum bloom/address/hash types plus Solidity ABI item and event-log decoding to JSONB. | TYPE | — | Rust | 11–16 | 4 |
| sid | 0.0.0 | Sortable labeled 128-bit identifier type with compact human-readable encoding. | TYPE | — | Rust | — | 4 |
| dna | 1.0 | Compact DNA sequence and k-mer types with comparison, validation, and analysis functions. | TYPE | MIT | C | — | 3 |
| pg_chainutils | 0.2.4 | Blockchain utility types and functions for PostgreSQL, built with pgrx. | TYPE | MIT | Rust | 17 | 3 |
| pg_color | 1.1 | Color data type for PostgreSQL | TYPE | Apache-2.0 | C | 10 | 3 |
| pg_duration | 1.0.2 | data type for representing durations | TYPE | MIT | C | 17–18 | 3 |
| pg_erlang_term | 0.0.1 | PostgreSQL type for encoding, storing, and decoding Erlang External Term Format values. | TYPE | PostgreSQL | C | — | 3 |
| pgbdd | 0.0.1 | Provides bdd and dictionary data types. | TYPE | GPL-3.0 | C | — | 3 |
| salesforce_id | 1.0 | Compact 12-byte PostgreSQL type with casts, comparison operators, and B-tree/hash operator classes for Salesforce IDs. | TYPE | PostgreSQL | C | — | 3 |
| student | 1.0 | Let's learn how to add types in PostgreSQL 👨🏻💻 | TYPE | — | C | — | 3 |
| xnode | 0.7.2 | Implementation of XML using DOM. | TYPE | PostgreSQL | C | — | 3 |
| asn1oid | 1.6 | asn1oid extension | TYPE | GPL-3.0 | C | 14–18 | 2 |
| b64enc | 0.0.1 | Rust/C extension that defines a b64enc base type with URL-safe Base64 input and output functions. | TYPE | — | Rust | — | 2 |
| bankbsb | 0.0.1 | Postgres Extension for Australian BSB numbers data type. | TYPE | MIT | C | — | 2 |
| base32_4b | 0.0.1 | Base32 data type stored in four bytes with comparison operators. | TYPE | PostgreSQL | C | 10–18 | 2 |
| cert | 0.1.1 | PostgreSQL data types and functions for X.509 certificates, certificate requests, and related OpenSSL objects. | TYPE | PostgreSQL | C | — | 2 |