overview of system data types NAME system_data_types - overview of system data types DESCRIPTION siginfo_t Include : <signal.h> . Alternatively, <sys/wait.h> . typedef struct { int…define a new index NAME CREATE_INDEX - define a new index SYNOPSIS CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] name ] ON [ ONLY ] table_name [ USING method ] ( { c…change the definition of a table NAME ALTER_TABLE - change the definition of a table SYNOPSIS ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ] action [, ... ] ALTER TABLE [ IF EXISTS …show the execution plan of a statement NAME EXPLAIN - show the execution plan of a statement SYNOPSIS EXPLAIN [ ( option [, ...] ) ] statement where option can be one of: ANALYZE […empty a table or set of tables NAME TRUNCATE - empty a table or set of tables SYNOPSIS TRUNCATE [ TABLE ] [ ONLY ] name [ * ] [, ... ] [ RESTART IDENTITY | CONTINUE IDENTITY ] [ CA…cluster a table according to an index NAME CLUSTER - cluster a table according to an index SYNOPSIS CLUSTER [ ( option [, ...] ) ] [ table_name [ USING index_name ] ] where option …replace the contents of a materialized view NAME REFRESH_MATERIALIZED_VIEW - replace the contents of a materialized view SYNOPSIS REFRESH MATERIALIZED VIEW [ CONCURRENTLY ] name [ …overview of Non-Uniform Memory Architecture NAME numa - overview of Non-Uniform Memory Architecture DESCRIPTION Non-Uniform Memory Access (NUMA) refers to multiprocessor systems wh…define a new table NAME CREATE_TABLE - define a new table SYNOPSIS CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name ( [ { column_nam…rebuild indexes NAME REINDEX - rebuild indexes SYNOPSIS REINDEX [ ( option [, ...] ) ] { INDEX | TABLE | SCHEMA } [ CONCURRENTLY ] name REINDEX [ ( option [, ...] ) ] { DATABASE | …garbage-collect and optionally analyze a database NAME VACUUM - garbage-collect and optionally analyze a database SYNOPSIS VACUUM [ ( option [, ...] ) ] [ table_and_columns [, ...]…define a new function NAME CREATE_FUNCTION - define a new function SYNOPSIS CREATE [ OR REPLACE ] FUNCTION name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ]…ISO/IEC 8859-4 character set encoded in octal, decimal, and hexadecimal NAME iso_8859-4 - ISO/IEC 8859-4 character set encoded in octal, decimal, and hexadecimal DESCRIPTION The IS…ISO/IEC 8859-4 character set encoded in octal, decimal, and hexadecimal NAME iso_8859-4 - ISO/IEC 8859-4 character set encoded in octal, decimal, and hexadecimal DESCRIPTION The IS…ISO/IEC 8859-4 character set encoded in octal, decimal, and hexadecimal NAME iso_8859-4 - ISO/IEC 8859-4 character set encoded in octal, decimal, and hexadecimal DESCRIPTION The IS…ISO/IEC 8859-4 character set encoded in octal, decimal, and hexadecimal NAME iso_8859-4 - ISO/IEC 8859-4 character set encoded in octal, decimal, and hexadecimal DESCRIPTION The IS…POSIX threads NAME pthreads - POSIX threads DESCRIPTION POSIX.1 specifies a set of interfaces (functions, header files) for threaded programming commonly known as POSIX threads, or…retrieve rows from a query using a cursor NAME FETCH - retrieve rows from a query using a cursor SYNOPSIS FETCH [ direction ] [ FROM | IN ] cursor_name where direction can be one o…ISO/IEC 8859-6 character set encoded in octal, decimal, and hexadecimal NAME iso_8859-6 - ISO/IEC 8859-6 character set encoded in octal, decimal, and hexadecimal DESCRIPTION The IS…ISO/IEC 8859-6 character set encoded in octal, decimal, and hexadecimal NAME iso_8859-6 - ISO/IEC 8859-6 character set encoded in octal, decimal, and hexadecimal DESCRIPTION The IS…