select open change scope Open full search

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

Extensions / Functions and aggregates

merge_ips

Functions to merge IP addresses, ignoring gaps

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

Overview

Packagemerge_ips
Version1.0
RepositoryUnspecified
Extension typeSQL only
Project statusArchived
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemamerge_ips
Stars3
Latest commit2018-01-10
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

pg_inet_addrLists the IPv4 and IPv6 addresses and netmasks assigned to the PostgreSQL server host network interfaces.
inetrangeRange type for PostgreSQL inet values with range operators and GiST indexing support.
statsdC client functions for sending counters, gauges, and timings to StatsD over UDP.
gms_tcpprovides TCP/IP client=side access functionality in PL/SQL
pgsocketsend bytes from PostgreSQL to a TCP/IP socket
connection_limitsEnforce connection quotas by user, database, source IP or hostname, including combined rules.
cidrTransform an IPv4 or IPv6 address range into the minimal set of CIDR blocks
r53dbr53db, the PostgreSQL Foreign Data Wrapper for the AWS Route53 Database service