📦 postgresql18-doc

297 pages · page 2 of 2

P (continued)

pg_test_fsync(1)determine fastest wal_sync_method for PostgreSQL✨
pg_test_timing(1)measure timing overhead✨
pg_upgrade(1)upgrade a PostgreSQL server instance✨
pg_verifybackup(1)verify the integrity of a base backup of a PostgreSQL cluster✨
pg_waldump(1)display a human-readable rendering of the write-ahead log of a PostgreSQL database cluster✨
pg_walsummary(1)print contents of WAL summary files✨
pgbench(1)run a benchmark test on PostgreSQL✨
postgres(1)PostgreSQL database server✨
PREPARE(7)prepare a statement for execution✨
PREPARE_TRANSACTION(7)prepare the current transaction for two-phase commit✨
psql(1)PostgreSQL interactive terminal✨

R

REASSIGN_OWNED(7)change the ownership of database objects owned by a database role✨
REFRESH_MATERIALIZED_VIEW(7)replace the contents of a materialized view✨
REINDEX(7)rebuild indexes✨
reindexdb(1)reindex a PostgreSQL database✨
RELEASE_SAVEPOINT(7)release a previously defined savepoint✨
RESET(7)restore the value of a run-time parameter to the default value✨
REVOKE(7)remove access privileges✨
ROLLBACK(7)abort the current transaction✨
ROLLBACK_PREPARED(7)cancel a transaction that was earlier prepared for two-phase commit✨
ROLLBACK_TO_SAVEPOINT(7)roll back to a savepoint✨

S

SAVEPOINT(7)define a new savepoint within the current transaction✨
SECURITY_LABEL(7)define or change a security label applied to an object✨
SELECT(7)retrieve rows from a table or view✨
SELECT_INTO(7)define a new table from the results of a query✨
SET(7)change a run-time parameter✨
SET_CONSTRAINTS(7)set constraint check timing for the current transaction✨
SET_ROLE(7)set the current user identifier of the current session✨
SET_SESSION_AUTHORIZATION(7)set the session user identifier and the current user identifier of the current session✨
SET_TRANSACTION(7)set the characteristics of the current transaction✨
SHOW(7)show the value of a run-time parameter✨
SPI_commit(3)commit the current transaction✨
SPI_commit_and_chain(3)commit the current transaction✨
SPI_connect(3)connect a C function to the SPI manager✨
SPI_connect_ext(3)connect a C function to the SPI manager✨
SPI_copytuple(3)make a copy of a row in the upper executor context✨
SPI_cursor_close(3)close a cursor✨
SPI_cursor_fetch(3)fetch some rows from a cursor✨
SPI_cursor_find(3)find an existing cursor by name✨
SPI_cursor_move(3)move a cursor✨
SPI_cursor_open(3)set up a cursor using a statement created with SPI_prepare✨
SPI_cursor_open_with_args(3)set up a cursor using a query and parameters✨
SPI_cursor_open_with_paramlist(3)set up a cursor using parameters✨
SPI_cursor_parse_open(3)set up a cursor using a query string and parameters✨
SPI_exec(3)execute a read/write command✨
SPI_execp(3)execute a statement in read/write mode✨
SPI_execute(3)execute a command✨
SPI_execute_extended(3)execute a command with out-of-line parameters✨
SPI_execute_plan(3)execute a statement prepared by SPI_prepare✨
SPI_execute_plan_extended(3)execute a statement prepared by SPI_prepare✨
SPI_execute_plan_with_paramlist(3)execute a statement prepared by SPI_prepare✨
SPI_execute_with_args(3)execute a command with out-of-line parameters✨
SPI_finish(3)disconnect a C function from the SPI manager✨
SPI_fname(3)determine the column name for the specified column number✨
SPI_fnumber(3)determine the column number for the specified column name✨
SPI_freeplan(3)free a previously saved prepared statement✨
SPI_freetuple(3)free a row allocated in the upper executor context✨
SPI_freetuptable(3)free a row set created by SPI_execute or a similar function✨
SPI_getargcount(3)return the number of arguments needed by a statement prepared by SPI_prepare✨
SPI_getargtypeid(3)return the data type OID for an argument of a statement prepared by SPI_prepare✨
SPI_getbinval(3)return the binary value of the specified column✨
SPI_getnspname(3)return the namespace of the specified relation✨
SPI_getrelname(3)return the name of the specified relation✨
SPI_gettype(3)return the data type name of the specified column✨
SPI_gettypeid(3)return the data type OID of the specified column✨
SPI_getvalue(3)return the string value of the specified column✨
SPI_is_cursor_plan(3)return true if a statement prepared by SPI_prepare can be used with SPI_cursor_open✨
SPI_keepplan(3)save a prepared statement✨
SPI_modifytuple(3)create a row by replacing selected fields of a given row✨
SPI_palloc(3)allocate memory in the upper executor context✨
SPI_pfree(3)free memory in the upper executor context✨
SPI_prepare(3)prepare a statement, without executing it yet✨
SPI_prepare_cursor(3)prepare a statement, without executing it yet✨
SPI_prepare_extended(3)prepare a statement, without executing it yet✨
SPI_prepare_params(3)prepare a statement, without executing it yet✨
SPI_register_relation(3)make an ephemeral named relation available by name in SPI queries✨
SPI_register_trigger_data(3)make ephemeral trigger data available in SPI queries✨
SPI_repalloc(3)reallocate memory in the upper executor context✨
SPI_result_code_string(3)return error code as string✨
SPI_returntuple(3)prepare to return a tuple as a Datum✨
SPI_rollback(3)abort the current transaction✨
SPI_rollback_and_chain(3)abort the current transaction✨
SPI_saveplan(3)save a prepared statement✨
SPI_scroll_cursor_fetch(3)fetch some rows from a cursor✨
SPI_scroll_cursor_move(3)move a cursor✨
SPI_start_transaction(3)obsolete function✨
SPI_unregister_relation(3)remove an ephemeral named relation from the registry✨
START_TRANSACTION(7)start a transaction block✨

T

TABLE(7)retrieve rows from a table or view✨
TRUNCATE(7)empty a table or set of tables✨

U

UNLISTEN(7)stop listening for a notification✨
UPDATE(7)update rows of a table✨

V

VACUUM(7)garbage-collect and optionally analyze a database✨
vacuumdb(1)garbage-collect and analyze a PostgreSQL database✨
vacuumlo(1)remove orphaned large objects from a PostgreSQL database✨
VALUES(7)compute a set of rows✨

W

WITH(7)retrieve rows from a table or view✨