This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Category: FUNC

FUNC: Functionality such as sync/async HTTP, GZIP, JWT, SaltedHash, Extra Window Aggs, PCRE, ICU, ID & Rand Generator, etc…

1: pg_summarize
2: topn
3: gzip
4: zstd
5: http
6: pg_net
7: pg_html5_email_address
8: pgsql_tweaks
9: pg_extra_time
10: timeit
11: count_distinct
12: extra_window_functions
13: first_last_agg
14: tdigest
15: aggs_for_vecs
16: aggs_for_arrays
17: arraymath
18: quantile
19: lower_quantile
20: pg_idkit
21: pg_uuidv7
22: permuteseq
23: pg_hashids
24: sequential_uuids
25: pg_math
26: random
27: base36
28: base62
29: pg_base58
30: floatvec
31: financial
32: pgjwt
33: pg_hashlib
34: shacrypt
35: cryptint
36: pguecc
37: pgpcre
38: icu_ext
39: pgqr
40: envvar
41: pg_protobuf
42: url_encode
43: refint
44: autoinc
45: insert_username
46: moddatetime
47: tsm_system_time
48: dict_xsyn
49: tsm_system_rows
50: tcn
51: uuid-ossp
52: btree_gist
53: btree_gin
54: intarray
55: intagg
56: dict_int
57: unaccent

FUNC category has 57 available extensions:

Extension (URL)	Alias	Repo	Version	Category	License	Description
pg_summarize	`pg_summarize`	PIGSTY	0.0.0	`FUNC`	PostgreSQL	Text Summarization using LLMs. Built using pgrx
topn	`topn`	PGDG	2.6.0	`FUNC`	AGPLv3	type for top-n JSONB
gzip	`pg_gzip`	PGDG	1.0	`FUNC`	MIT	gzip and gunzip functions.
zstd	`pg_zstd`	PIGSTY	1.1.0	`FUNC`	ISC	Zstandard compression algorithm implementation in PostgreSQL
http	`pg_http`	PGDG	1.6	`FUNC`	MIT	HTTP client for PostgreSQL, allows web page retrieval inside the database.
pg_net	`pg_net`	PIGSTY	0.9.2	`FUNC`	Apache-2.0	Async HTTP Requests
pg_html5_email_address	`pg_html5_email_address`	PIGSTY	1.2.3	`FUNC`	PostgreSQL	PostgreSQL email validation that is consistent with the HTML5 spec
pgsql_tweaks	`pgsql_tweaks`	PGDG	0.10.6	`FUNC`	PostgreSQL	Some functions and views for daily usage
pg_extra_time	`pg_extra_time`	PGDG	1.1.3	`FUNC`	PostgreSQL	Some date time functions and operators that,
timeit	`pg_timeit`	PIGSTY	1.0	`FUNC`	PostgreSQL	High-accuracy timing of SQL expressions
count_distinct	`count_distinct`	PGDG	3.0.1	`FUNC`	BSD 2	An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
extra_window_functions	`extra_window_functions`	PGDG	1.0	`FUNC`	PostgreSQL	Extra Window Functions for PostgreSQL
first_last_agg	`first_last_agg`	PIGSTY	0.1.4	`FUNC`	PostgreSQL	first() and last() aggregate functions
tdigest	`tdigest`	PGDG	1.4.1	`FUNC`	Apache-2.0	Provides tdigest aggregate function.
aggs_for_vecs	`aggs_for_vecs`	PIGSTY	1.3.0	`FUNC`	MIT	Aggregate functions for array inputs
aggs_for_arrays	`aggs_for_arrays`	PIGSTY	1.3.2	`FUNC`	MIT	Various functions for computing statistics on arrays of numbers
arraymath	`pg_arraymath`	PIGSTY	1.1	`FUNC`	MIT	Array math and operators that work element by element on the contents of arrays
quantile	`quantile`	PIGSTY	1.1.7	`FUNC`	BSD	Quantile aggregation function
lower_quantile	`lower_quantile`	PIGSTY	1.0.0	`FUNC`	BSD-2	Lower quantile aggregate function
pg_idkit	`pg_idkit`	PIGSTY	0.2.4	`FUNC`	Apache-2.0	multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
pg_uuidv7	`pg_uuidv7`	PGDG	1.6	`FUNC`	MPLv2	pg_uuidv7: create UUIDv7 values in postgres
permuteseq	`permuteseq`	PIGSTY	1.2	`FUNC`	PostgreSQL	Pseudo-randomly permute sequences with a format-preserving encryption on elements
pg_hashids	`pg_hashids`	PIGSTY	1.3	`FUNC`	MIT	Short unique id generator for PostgreSQL, using hashids
sequential_uuids	`sequential_uuids`	PGDG	1.0.2	`FUNC`	MIT	generator of sequential UUIDs
pg_math	`pg_math`	PIGSTY	1.0	`FUNC`	GPLv3	GSL statistical functions for postgresql
random	`pg_random`	PIGSTY	2.0.0-dev	`FUNC`	PostgreSQL	random data generator
base36	`pg_base36`	PIGSTY	1.0.0	`FUNC`	MIT	Integer Base36 types
base62	`pg_base62`	PIGSTY	0.0.1	`FUNC`	MIT	Base62 extension for PostgreSQL
pg_base58	`pg_base58`	PIGSTY	0.0.1	`FUNC`	MIT	Base58 Encoder/Decoder Extension for PostgreSQL
floatvec	`floatvec`	PIGSTY	1.0.1	`FUNC`	MIT	Math for vectors (arrays) of numbers
financial	`pg_financial`	PIGSTY	1.0.1	`FUNC`	PostgreSQL	Financial aggregate functions
pgjwt	`pgjwt`	PIGSTY	0.2.0	`FUNC`	MIT	JSON Web Token API for Postgresql
pg_hashlib	`pg_hashlib`	PIGSTY	1.1	`FUNC`	PostgreSQL	Stable hash functions for Postgres
shacrypt	`shacrypt`	PIGSTY	1.1	`FUNC`	PostgreSQL	Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
cryptint	`cryptint`	PIGSTY	1.0.0	`FUNC`	PostgreSQL	Encryption functions for int and bigint values
pguecc	`pg_ecdsa`	PIGSTY	1.0	`FUNC`	BSD-2	uECC bindings for Postgres
pgpcre	`pgpcre`	PIGSTY	1	`FUNC`	PostgreSQL	Perl Compatible Regular Expression functions
icu_ext	`icu_ext`	PIGSTY	1.9	`FUNC`	PostgreSQL	Access ICU functions
pgqr	`pgqr`	PIGSTY	1.0	`FUNC`	BSD-3	QR Code generator from PostgreSQL
envvar	`envvar`	PIGSTY	1.0.0	`FUNC`	PostgreSQL	Fetch the value of an environment variable
pg_protobuf	`pg_protobuf`	PIGSTY	1.0	`FUNC`	MIT	Protobuf support for PostgreSQL
url_encode	`url_encode`	PIGSTY	1.2	`FUNC`	PostgreSQL	url_encode, url_decode functions
refint	`refint`	CONTRIB	1.0	`FUNC`	PostgreSQL	functions for implementing referential integrity (obsolete)
autoinc	`autoinc`	CONTRIB	1.0	`FUNC`	PostgreSQL	functions for autoincrementing fields
insert_username	`insert_username`	CONTRIB	1.0	`FUNC`	PostgreSQL	functions for tracking who changed a table
moddatetime	`moddatetime`	CONTRIB	1.0	`FUNC`	PostgreSQL	functions for tracking last modification time
tsm_system_time	`tsm_system_time`	CONTRIB	1.0	`FUNC`	PostgreSQL	TABLESAMPLE method which accepts time in milliseconds as a limit
dict_xsyn	`dict_xsyn`	CONTRIB	1.0	`FUNC`	PostgreSQL	text search dictionary template for extended synonym processing
tsm_system_rows	`tsm_system_rows`	CONTRIB	1.0	`FUNC`	PostgreSQL	TABLESAMPLE method which accepts number of rows as a limit
tcn	`tcn`	CONTRIB	1.0	`FUNC`	PostgreSQL	Triggered change notifications
uuid-ossp	`uuid-ossp`	CONTRIB	1.1	`FUNC`	PostgreSQL	generate universally unique identifiers (UUIDs)
btree_gist	`btree_gist`	CONTRIB	1.7	`FUNC`	PostgreSQL	support for indexing common datatypes in GiST
btree_gin	`btree_gin`	CONTRIB	1.3	`FUNC`	PostgreSQL	support for indexing common datatypes in GIN
intarray	`intarray`	CONTRIB	1.5	`FUNC`	PostgreSQL	functions, operators, and index support for 1-D arrays of integers
intagg	`intagg`	CONTRIB	1.1	`FUNC`	PostgreSQL	integer aggregator and enumerator (obsolete)
dict_int	`dict_int`	CONTRIB	1.0	`FUNC`	PostgreSQL	text search dictionary template for integers
unaccent	`unaccent`	CONTRIB	1.1	`FUNC`	PostgreSQL	text search dictionary that removes accents

1 - pg_summarize

Text Summarization using LLMs. Built using pgrx

Overview

PIGSTY 3rd Party Extension: pg_summarize : Text Summarization using LLMs. Built using pgrx

Information

ID: 1250
Name: pg_summarize
Alias: pg_summarize
Category: FUNC
Website: https://github.com/HexaCluster/pg_summarize
License: PostgreSQL License
Language: Rust
Tags: pgrx
Comment:

Metadata

Version: 0.0.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_summarize_$v
RPM Ver : 0.0.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-summarize
DEB Ver : 0.0.0
DEB Deps: Nil

Details

2 - topn

type for top-n JSONB

Overview

PGDG 1st Party Extension: topn : type for top-n JSONB

Information

ID: 3000
Name: topn
Alias: topn
Category: FUNC
Website: https://github.com/citusdata/postgresql-topn
License: AGPLv3 License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 2.6.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: topn_$v*
RPM Ver : 2.6.0
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-topn
DEB Ver : 2.6.0
DEB Deps: Nil

Details

3 - gzip

gzip and gunzip functions.

Overview

PGDG 3rd Party Extension: pg_gzip : gzip and gunzip functions.

Information

ID: 3010
Name: gzip
Alias: pg_gzip
Category: FUNC
Website: https://github.com/pramsey/pgsql-gzip
License: MIT License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pgsql_gzip_$v*
RPM Ver : 1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-gzip
DEB Ver : 1.0
DEB Deps: Nil

Details

4 - zstd

Zstandard compression algorithm implementation in PostgreSQL

Overview

PIGSTY 3rd Party Extension: pg_zstd : Zstandard compression algorithm implementation in PostgreSQL

Information

ID: 3020
Name: zstd
Alias: pg_zstd
Category: FUNC
Website: https://github.com/grahamedgecombe/pgzstd
License: ISC License
Language: C
Tags: N/A
Comment:

Metadata

Version: 1.1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_zstd_$v*
RPM Ver : 1.1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-zstd
DEB Ver : 1.1.0
DEB Deps: Nil

Details

5 - http

HTTP client for PostgreSQL, allows web page retrieval inside the database.

Overview

PGDG 1st Party Extension: pg_http : HTTP client for PostgreSQL, allows web page retrieval inside the database.

Information

ID: 3030
Name: http
Alias: pg_http
Category: FUNC
Website: https://github.com/pramsey/pgsql-http
License: MIT License
Language: C
Tags: supabase
Comment: 无

Metadata

Version: 1.6
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pgsql_http_$v*
RPM Ver : 1.6
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-http
DEB Ver : 1.6
DEB Deps: Nil

Details

6 - pg_net

Async HTTP Requests

Overview

PIGSTY 3rd Party Extension: pg_net : Async HTTP Requests

Information

ID: 3040
Name: pg_net
Alias: pg_net
Category: FUNC
Website: https://github.com/supabase/pg_net
License: Apache-2.0 License
Language: C
Tags: supabase
Comment: 无

Metadata

Version: 0.9.2
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_net_$v*
RPM Ver : 0.9.2
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-net
DEB Ver : 0.9.2
DEB Deps: Nil

Details

7 - pg_html5_email_address

PostgreSQL email validation that is consistent with the HTML5 spec

Overview

PIGSTY 3rd Party Extension: pg_html5_email_address : PostgreSQL email validation that is consistent with the HTML5 spec

Information

ID: 3050
Name: pg_html5_email_address
Alias: pg_html5_email_address
Category: FUNC
Website: https://github.com/bigsmoke/pg_html5_email_address
License: PostgreSQL License
Language: Pure SQL
Tags: N/A
Comment: 无

Metadata

Version: 1.2.3
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_html5_email_address_$v
RPM Ver : 1.2.3
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-html5-email-address
DEB Ver : 1.2.3
DEB Deps: Nil

Details

8 - pgsql_tweaks

Some functions and views for daily usage

Overview

PGDG 3rd Party Extension: pgsql_tweaks : Some functions and views for daily usage

Information

ID: 3060
Name: pgsql_tweaks
Alias: pgsql_tweaks
Category: FUNC
Website: https://github.com/sjstoelting/pgsql-tweaks
License: PostgreSQL License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 0.10.6
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pgsql_tweaks_$v*
RPM Ver : 0.10.6
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pgsql-tweaks
DEB Ver : 0.10.4
DEB Deps: Nil

Details

9 - pg_extra_time

Some date time functions and operators that,

Overview

PGDG 3rd Party Extension: pg_extra_time : Some date time functions and operators that,

Information

ID: 3070
Name: pg_extra_time
Alias: pg_extra_time
Category: FUNC
Website: https://github.com/bigsmoke/pg_extra_time
License: PostgreSQL License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.1.3
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pg_extra_time_$v*
RPM Ver : 1.1.3
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-extra-time
DEB Ver : 1.1.3
DEB Deps: Nil

Details

10 - timeit

High-accuracy timing of SQL expressions

Overview

PIGSTY 3rd Party Extension: pg_timeit : High-accuracy timing of SQL expressions

Information

ID: 3080
Name: timeit
Alias: pg_timeit
Category: FUNC
Website: https://github.com/joelonsql/pg-timeit
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_timeit_$v*
RPM Ver : 1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-timeit
DEB Ver : 1.0
DEB Deps: Nil

Details

11 - count_distinct

An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate

Overview

PGDG 3rd Party Extension: count_distinct : An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate

Information

ID: 3100
Name: count_distinct
Alias: count_distinct
Category: FUNC
Website: https://github.com/tvondra/count_distinct
License: BSD 2 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 3.0.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: count_distinct_$v*
RPM Ver : 3.0.1
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-count-distinct
DEB Ver : 3.0.2
DEB Deps: Nil

Details

12 - extra_window_functions

Extra Window Functions for PostgreSQL

Overview

PGDG 1st Party Extension: extra_window_functions : Extra Window Functions for PostgreSQL

Information

ID: 3110
Name: extra_window_functions
Alias: extra_window_functions
Category: FUNC
Website: https://github.com/xocolatl/extra_window_functions
License: PostgreSQL License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: extra_window_functions_$v*
RPM Ver : 1.0
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-extra-window-functions
DEB Ver : 1.0
DEB Deps: Nil

Details

13 - first_last_agg

first() and last() aggregate functions

Overview

PIGSTY 3rd Party Extension: first_last_agg : first() and last() aggregate functions

Information

ID: 3120
Name: first_last_agg
Alias: first_last_agg
Category: FUNC
Website: https://github.com/wulczer/first_last_agg
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 0.1.4
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: first_last_agg_$v
RPM Ver : 0.1.4
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-first-last-agg
DEB Ver : 0.1.4
DEB Deps: Nil

Details

14 - tdigest

Provides tdigest aggregate function.

Overview

PGDG 1st Party Extension: tdigest : Provides tdigest aggregate function.

Information

ID: 3130
Name: tdigest
Alias: tdigest
Category: FUNC
Website: https://github.com/tdunning/t-digest
License: Apache-2.0 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.4.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: tdigest_$v*
RPM Ver : 1.4.1
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-tdigest
DEB Ver : 1.4.1
DEB Deps: Nil

Details

15 - aggs_for_vecs

Aggregate functions for array inputs

Overview

PIGSTY 3rd Party Extension: aggs_for_vecs : Aggregate functions for array inputs

Information

ID: 3140
Name: aggs_for_vecs
Alias: aggs_for_vecs
Category: FUNC
Website: https://github.com/pjungwir/aggs_for_vecs
License: MIT License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.3.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: aggs_for_vecs_$v*
RPM Ver : 1.3.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-aggs-for-vecs
DEB Ver : 1.3.0
DEB Deps: Nil

Details

16 - aggs_for_arrays

Various functions for computing statistics on arrays of numbers

Overview

PIGSTY 3rd Party Extension: aggs_for_arrays : Various functions for computing statistics on arrays of numbers

Information

ID: 3150
Name: aggs_for_arrays
Alias: aggs_for_arrays
Category: FUNC
Website: https://github.com/pjungwir/aggs_for_arrays
License: MIT License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.3.2
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: aggs_for_arrays_$v*
RPM Ver : 1.3.2
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-aggs-for-arrays
DEB Ver : 1.3.2
DEB Deps: Nil

Details

17 - arraymath

Array math and operators that work element by element on the contents of arrays

Overview

PIGSTY 3rd Party Extension: pg_arraymath : Array math and operators that work element by element on the contents of arrays

Information

ID: 3160
Name: arraymath
Alias: pg_arraymath
Category: FUNC
Website: https://github.com/pramsey/pgsql-arraymath
License: MIT License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_arraymath_$v*
RPM Ver : 1.1
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-arraymath
DEB Ver : 1.1
DEB Deps: Nil

Details

18 - quantile

Quantile aggregation function

Overview

PIGSTY 3rd Party Extension: quantile : Quantile aggregation function

Information

ID: 3170
Name: quantile
Alias: quantile
Category: FUNC
Website: https://github.com/tvondra/quantile
License: BSD License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.1.7
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: quantile_$v*
RPM Ver : 1.1.7
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-quantile
DEB Ver : 1.1.7
DEB Deps: Nil

Details

19 - lower_quantile

Lower quantile aggregate function

Overview

PIGSTY 3rd Party Extension: lower_quantile : Lower quantile aggregate function

Information

ID: 3180
Name: lower_quantile
Alias: lower_quantile
Category: FUNC
Website: https://github.com/tvondra/lower_quantile
License: BSD-2 License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: lower_quantile_$v*
RPM Ver : 1.0.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-lower-quantile
DEB Ver : 1.0.0
DEB Deps: Nil

Details

20 - pg_idkit

multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)

Overview

PIGSTY 3rd Party Extension: pg_idkit : multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)

Information

ID: 3200
Name: pg_idkit
Alias: pg_idkit
Category: FUNC
Website: https://github.com/VADOSWARE/pg_idkit
License: Apache-2.0 License
Language: Rust
Tags: pgrx
Comment:

Metadata

Version: 0.2.4
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_idkit_$v
RPM Ver : 0.2.4
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-idkit
DEB Ver : 0.2.4
DEB Deps: Nil

Details

21 - pg_uuidv7

pg_uuidv7: create UUIDv7 values in postgres

Overview

PGDG 3rd Party Extension: pg_uuidv7 : pg_uuidv7: create UUIDv7 values in postgres

Information

ID: 3210
Name: pg_uuidv7
Alias: pg_uuidv7
Category: FUNC
Website: https://github.com/fboulnois/pg_uuidv7
License: MPLv2 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.6
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pg_uuidv7_$v*
RPM Ver : 1.6
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-uuidv7
DEB Ver : 1.6
DEB Deps: Nil

Details

22 - permuteseq

Pseudo-randomly permute sequences with a format-preserving encryption on elements

Overview

PIGSTY 3rd Party Extension: permuteseq : Pseudo-randomly permute sequences with a format-preserving encryption on elements

Information

ID: 3220
Name: permuteseq
Alias: permuteseq
Category: FUNC
Website: https://github.com/dverite/permuteseq
License: PostgreSQL License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.2
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: permuteseq_$v*
RPM Ver : 1.2
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-permuteseq
DEB Ver : 1.2
DEB Deps: Nil

Details

23 - pg_hashids

Short unique id generator for PostgreSQL, using hashids

Overview

PIGSTY 3rd Party Extension: pg_hashids : Short unique id generator for PostgreSQL, using hashids

Information

ID: 3230
Name: pg_hashids
Alias: pg_hashids
Category: FUNC
Website: https://github.com/iCyberon/pg_hashids
License: MIT License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.3
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_hashids_$v*
RPM Ver : 1.3
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-hashids
DEB Ver : 1.3
DEB Deps: Nil

Details

24 - sequential_uuids

generator of sequential UUIDs

Overview

PGDG 3rd Party Extension: sequential_uuids : generator of sequential UUIDs

Information

ID: 3240
Name: sequential_uuids
Alias: sequential_uuids
Category: FUNC
Website: https://github.com/tvondra/sequential-uuids
License: MIT License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0.2
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: sequential_uuids_$v*
RPM Ver : 1.0.2
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-sequential-uuids
DEB Ver : 1.0.2
DEB Deps: Nil

Details

25 - pg_math

GSL statistical functions for postgresql

Overview

PIGSTY 3rd Party Extension: pg_math : GSL statistical functions for postgresql

Information

ID: 3300
Name: pg_math
Alias: pg_math
Category: FUNC
Website: https://github.com/chanukyasds/pg_math
License: GPLv3 License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_math_$v*
RPM Ver : 1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-math
DEB Ver : 1.0
DEB Deps: Nil

Details

26 - random

random data generator

Overview

PIGSTY 3rd Party Extension: pg_random : random data generator

Information

ID: 3310
Name: random
Alias: pg_random
Category: FUNC
Website: https://github.com/tvondra/random
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 2.0.0-dev
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_random_$v*
RPM Ver : 2.0.0-dev
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-random
DEB Ver : 2.0.0-dev
DEB Deps: Nil

Details

27 - base36

Integer Base36 types

Overview

PIGSTY 3rd Party Extension: pg_base36 : Integer Base36 types

Information

ID: 3320
Name: base36
Alias: pg_base36
Category: FUNC
Website: https://github.com/adjust/pg-base36
License: MIT License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_base36_$v*
RPM Ver : 1.0.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-base36
DEB Ver : 1.0.0
DEB Deps: Nil

Details

28 - base62

Base62 extension for PostgreSQL

Overview

PIGSTY 3rd Party Extension: pg_base62 : Base62 extension for PostgreSQL

Information

ID: 3330
Name: base62
Alias: pg_base62
Category: FUNC
Website: https://github.com/adjust/pg-base62
License: MIT License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 0.0.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_base62_$v*
RPM Ver : 0.0.1
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-base62
DEB Ver : 0.0.1
DEB Deps: Nil

Details

29 - pg_base58

Base58 Encoder/Decoder Extension for PostgreSQL

Overview

PIGSTY 3rd Party Extension: pg_base58 : Base58 Encoder/Decoder Extension for PostgreSQL

Information

ID: 3340
Name: pg_base58
Alias: pg_base58
Category: FUNC
Website: https://github.com/Fell-x27/pg_base58
License: MIT License
Language: Rust
Tags: pgrx
Comment: 无

Metadata

Version: 0.0.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_base58_$v
RPM Ver : 0.0.1
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-base58
DEB Ver : 0.0.1
DEB Deps: Nil

Details

30 - floatvec

Math for vectors (arrays) of numbers

Overview

PIGSTY 3rd Party Extension: floatvec : Math for vectors (arrays) of numbers

Information

ID: 3350
Name: floatvec
Alias: floatvec
Category: FUNC
Website: https://github.com/pjungwir/floatvec
License: MIT License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: floatvec_$v*
RPM Ver : 1.0.1
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-floatvec
DEB Ver : 1.0.1
DEB Deps: Nil

Details

31 - financial

Financial aggregate functions

Overview

PIGSTY 3rd Party Extension: pg_financial : Financial aggregate functions

Information

ID: 3360
Name: financial
Alias: pg_financial
Category: FUNC
Website: https://github.com/intgr/pg_financial
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_financial_$v*
RPM Ver : 1.0.1
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-financial
DEB Ver : 1.0.1
DEB Deps: Nil

Details

32 - pgjwt

JSON Web Token API for Postgresql

Overview

PIGSTY 3rd Party Extension: pgjwt : JSON Web Token API for Postgresql

Information

ID: 3400
Name: pgjwt
Alias: pgjwt
Category: FUNC
Website: https://github.com/michelp/pgjwt
License: MIT License
Language: Pure SQL
Tags: supabase
Comment: 无

Metadata

Version: 0.2.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pgjwt_$v*
RPM Ver : 0.2.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pgjwt
DEB Ver : 0.2.0
DEB Deps: Nil

Details

33 - pg_hashlib

Stable hash functions for Postgres

Overview

PIGSTY 3rd Party Extension: pg_hashlib : Stable hash functions for Postgres

Information

ID: 3410
Name: pg_hashlib
Alias: pg_hashlib
Category: FUNC
Website: https://github.com/markokr/pghashlib
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_hashlib_$v
RPM Ver : 1.1
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-hashlib
DEB Ver : 1.1
DEB Deps: Nil

Details

34 - shacrypt

Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes

Overview

PIGSTY 3rd Party Extension: shacrypt : Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes

Information

ID: 3420
Name: shacrypt
Alias: shacrypt
Category: FUNC
Website: https://github.com/dverite/postgres-shacrypt
License: PostgreSQL License
Language: Pure SQL
Tags: N/A
Comment: 无

Metadata

Version: 1.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: postgres_shacrypt_$v*
RPM Ver : 1.1
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-shacrypt
DEB Ver : 1.1
DEB Deps: Nil

Details

35 - cryptint

Encryption functions for int and bigint values

Overview

PIGSTY 3rd Party Extension: cryptint : Encryption functions for int and bigint values

Information

ID: 3430
Name: cryptint
Alias: cryptint
Category: FUNC
Website: https://github.com/dverite/cryptint
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: cryptint_$v*
RPM Ver : 1.0.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-cryptint
DEB Ver : 1.0.0
DEB Deps: Nil

Details

36 - pguecc

uECC bindings for Postgres

Overview

PIGSTY 3rd Party Extension: pg_ecdsa : uECC bindings for Postgres

Information

ID: 3440
Name: pguecc
Alias: pg_ecdsa
Category: FUNC
Website: https://github.com/ameensol/pg-ecdsa
License: BSD-2 License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_ecdsa_$v*
RPM Ver : 1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-ecdsa
DEB Ver : 1.0
DEB Deps: Nil

Details

37 - pgpcre

Perl Compatible Regular Expression functions

Overview

PIGSTY 3rd Party Extension: pgpcre : Perl Compatible Regular Expression functions

Information

ID: 3500
Name: pgpcre
Alias: pgpcre
Category: FUNC
Website: https://github.com/petere/pgpcre
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pgpcre_$v
RPM Ver : 1
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-pgpcre
DEB Ver : 1
DEB Deps: Nil

Details

38 - icu_ext

Access ICU functions

Overview

PIGSTY 3rd Party Extension: icu_ext : Access ICU functions

Information

ID: 3510
Name: icu_ext
Alias: icu_ext
Category: FUNC
Website: https://github.com/dverite/icu_ext
License: PostgreSQL License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.9
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: icu_ext_$v*
RPM Ver : 1.9
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-icu-ext
DEB Ver : 1.9
DEB Deps: Nil

Details

39 - pgqr

QR Code generator from PostgreSQL

Overview

PIGSTY 3rd Party Extension: pgqr : QR Code generator from PostgreSQL

Information

ID: 3520
Name: pgqr
Alias: pgqr
Category: FUNC
Website: https://github.com/AbdulYadi/pgqr
License: BSD-3 License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pgqr_$v*
RPM Ver : 1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pgqr
DEB Ver : 1.0
DEB Deps: Nil

Details

40 - envvar

Fetch the value of an environment variable

Overview

PIGSTY 3rd Party Extension: envvar : Fetch the value of an environment variable

Information

ID: 3530
Name: envvar
Alias: envvar
Category: FUNC
Website: https://github.com/theory/pg-envvar
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_envvar_$v*
RPM Ver : 1.0.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-envvar
DEB Ver : 1.0.0
DEB Deps: Nil

Details

41 - pg_protobuf

Protobuf support for PostgreSQL

Overview

PIGSTY 3rd Party Extension: pg_protobuf : Protobuf support for PostgreSQL

Information

ID: 3540
Name: pg_protobuf
Alias: pg_protobuf
Category: FUNC
Website: https://github.com/afiskon/pg_protobuf
License: MIT License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_protobuf_$v
RPM Ver : 1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-protobuf
DEB Ver : 1.0
DEB Deps: Nil

Details

42 - url_encode

url_encode, url_decode functions

Overview

PIGSTY 3rd Party Extension: url_encode : url_encode, url_decode functions

Information

ID: 3550
Name: url_encode
Alias: url_encode
Category: FUNC
Website: https://github.com/okbob/url_encode
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.2
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: url_encode_$v*
RPM Ver : 1.2
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-url-encode
DEB Ver : 1.2
DEB Deps: Nil

Details

43 - refint

functions for implementing referential integrity (obsolete)

Overview

CONTRIB Built-in Extension: refint : functions for implementing referential integrity (obsolete)

Information

ID: 3840
Name: refint
Alias: refint
Category: FUNC
Website: https://www.postgresql.org/docs/current/contrib-spi.html#CONTRIB-SPI-REFINT
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

44 - autoinc

functions for autoincrementing fields

Overview

CONTRIB Built-in Extension: autoinc : functions for autoincrementing fields

Information

ID: 3841
Name: autoinc
Alias: autoinc
Category: FUNC
Website: https://www.postgresql.org/docs/current/contrib-spi.html#CONTRIB-SPI-AUTOINC
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

45 - insert_username

functions for tracking who changed a table

Overview

CONTRIB Built-in Extension: insert_username : functions for tracking who changed a table

Information

ID: 3842
Name: insert_username
Alias: insert_username
Category: FUNC
Website: https://www.postgresql.org/docs/current/contrib-spi.html#CONTRIB-SPI-INSERT-USERNAME
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

46 - moddatetime

functions for tracking last modification time

Overview

CONTRIB Built-in Extension: moddatetime : functions for tracking last modification time

Information

ID: 3843
Name: moddatetime
Alias: moddatetime
Category: FUNC
Website: https://www.postgresql.org/docs/current/contrib-spi.html#CONTRIB-SPI-MODDATETIME
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

47 - tsm_system_time

TABLESAMPLE method which accepts time in milliseconds as a limit

Overview

CONTRIB Built-in Extension: tsm_system_time : TABLESAMPLE method which accepts time in milliseconds as a limit

Information

ID: 3850
Name: tsm_system_time
Alias: tsm_system_time
Category: FUNC
Website: https://www.postgresql.org/docs/current/tsm-system-time.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

48 - dict_xsyn

text search dictionary template for extended synonym processing

Overview

CONTRIB Built-in Extension: dict_xsyn : text search dictionary template for extended synonym processing

Information

ID: 3870
Name: dict_xsyn
Alias: dict_xsyn
Category: FUNC
Website: https://www.postgresql.org/docs/current/dict-xsyn.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

49 - tsm_system_rows

TABLESAMPLE method which accepts number of rows as a limit

Overview

CONTRIB Built-in Extension: tsm_system_rows : TABLESAMPLE method which accepts number of rows as a limit

Information

ID: 3880
Name: tsm_system_rows
Alias: tsm_system_rows
Category: FUNC
Website: https://www.postgresql.org/docs/current/tsm-system-rows.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

50 - tcn

Triggered change notifications

Overview

CONTRIB Built-in Extension: tcn : Triggered change notifications

Information

ID: 3890
Name: tcn
Alias: tcn
Category: FUNC
Website: https://www.postgresql.org/docs/current/tcn.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

51 - uuid-ossp

generate universally unique identifiers (UUIDs)

Overview

CONTRIB Built-in Extension: uuid-ossp : generate universally unique identifiers (UUIDs)

Information

ID: 3900
Name: uuid-ossp
Alias: uuid-ossp
Category: FUNC
Website: https://www.postgresql.org/docs/current/uuid-ossp.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

52 - btree_gist

support for indexing common datatypes in GiST

Overview

CONTRIB Built-in Extension: btree_gist : support for indexing common datatypes in GiST

Information

ID: 3910
Name: btree_gist
Alias: btree_gist
Category: FUNC
Website: https://www.postgresql.org/docs/current/btree-gist.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.7
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

53 - btree_gin

support for indexing common datatypes in GIN

Overview

CONTRIB Built-in Extension: btree_gin : support for indexing common datatypes in GIN

Information

ID: 3920
Name: btree_gin
Alias: btree_gin
Category: FUNC
Website: https://www.postgresql.org/docs/current/btree-gin.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.3
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

54 - intarray

functions, operators, and index support for 1-D arrays of integers

Overview

CONTRIB Built-in Extension: intarray : functions, operators, and index support for 1-D arrays of integers

Information

ID: 3930
Name: intarray
Alias: intarray
Category: FUNC
Website: https://www.postgresql.org/docs/current/intarray.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.5
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

55 - intagg

integer aggregator and enumerator (obsolete)

Overview

CONTRIB Built-in Extension: intagg : integer aggregator and enumerator (obsolete)

Information

ID: 3950
Name: intagg
Alias: intagg
Category: FUNC
Website: https://www.postgresql.org/docs/current/intagg.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

56 - dict_int

text search dictionary template for integers

Overview

CONTRIB Built-in Extension: dict_int : text search dictionary template for integers

Information

ID: 3960
Name: dict_int
Alias: dict_int
Category: FUNC
Website: https://www.postgresql.org/docs/current/dict-int.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

57 - unaccent

text search dictionary that removes accents

Overview

CONTRIB Built-in Extension: unaccent : text search dictionary that removes accents

Information

ID: 3990
Name: unaccent
Alias: unaccent
Category: FUNC
Website: https://www.postgresql.org/docs/current/unaccent.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension