bloom provides an index access method based on Bloom filters. A Bloom filter is a space-efficient data structure that is used to test whether an element is a member of a set. In the case of an index ...

Name of the table, index, view, etc.

Determines whether the remote IP address or the host name is provided to PAM modules through the PAM_RHOST item. By default, the IP address is used. Set this option to 1 to use the resolved host name ...

dblink_connect — opens a persistent connection to a remote database Only superusers may use dblink_connect to create non-password-authenticated and non-GSSAPI-authenticated connections. If ...

The pgtypes library maps PostgreSQL database types to C equivalents that can be used in C programs. It also offers functions to do basic calculations with those types within C, i.e., without the help ...

These examples and others can be found in the directory src/test/examples in the source code distribution.

Aggregate functions in PostgreSQL are defined in terms of state values and state transition functions. That is, an aggregate operates using a state value that is updated as each successive input row ...

GET DESCRIPTOR retrieves information about a query result set from an SQL descriptor area and stores it into host variables. A descriptor area is typically populated using FETCH or SELECT before using ...

#> text[] Get JSON object at specified path '{"a": {"b":{"c": "foo"}}}'::json#>'{a,b}' {"c": "foo"} @> jsonb Does the left JSON value contain the right JSON path ...

This will create a shared library file. On a Linux system, it will be named plperl.so. The extension may differ on other systems. The shared library should then be copied into the lib subdirectory of ...

pgadmin4-redhat-repo-2-1.noarch.rpm Nov. 11, 2024, 1:35 a.m. 9.9 KB ...