Search PostgreSQL documentation

pg_export_snapshotFunctionsReferencepg_export_snapshot System Administration Functions 10 Save the current snapshot and return its identifier pg_export_snapshot ( ) → text Save the current snapshot and return its identifier 11…Functions · System Administration Functions pg_filenode_relationFunctionsReferencepg_filenode_relation System Administration Functions 10 Find the relation associated with a given tablespace and filenode pg_filenode_relation ( tablespace oid, filenode oid ) → regclass Fin…Functions · System Administration Functions pg_function_is_visibleFunctionsReferencepg_function_is_visible System Information Functions And Operators 10 is function visible in search path pg_function_is_visible ( function_oid ) → boolean is function visible in search path 1…Functions · System Information Functions And Operators pg_get_aclFunctionsReferencepg_get_acl System Information Functions And Operators 18 Returns the ACL for a database object, specified by catalog OID, object OID and sub-object ID. This function returns NULL values for …Functions · System Information Functions And Operators pg_get_catalog_foreign_keysFunctionsReferencepg_get_catalog_foreign_keys System Information Functions And Operators 14 Returns a set of records describing the foreign key relationships that exist within the PostgreSQL system catalogs. …Functions · System Information Functions And Operators pg_get_constraintdefFunctionsReferencepg_get_constraintdef System Information Functions And Operators 10 get definition of a constraint pg_get_constraintdef ( constraint_oid ) → text get definition of a constraint pg_get_constra…Functions · System Information Functions And Operators pg_get_database_ddlFunctionsReferencepg_get_database_ddl System Information Functions And Operators 19 Reconstructs the CREATE DATABASE statement for the specified database, followed by ALTER DATABASE statements for connection …Functions · System Information Functions And Operators pg_get_exprFunctionsReferencepg_get_expr System Information Functions And Operators 10 decompile internal form of an expression, assuming that any Vars in it refer to the relation indicated by the second parameter pg_ge…Functions · System Information Functions And Operators pg_get_function_argumentsFunctionsReferencepg_get_function_arguments System Information Functions And Operators 10 get argument list of function's definition (with default values) pg_get_function_arguments ( func_oid ) → text get arg…Functions · System Information Functions And Operators pg_get_function_identity_argumentsFunctionsReferencepg_get_function_identity_arguments System Information Functions And Operators 10 get argument list to identify a function (without default values) pg_get_function_identity_arguments ( func_o…Functions · System Information Functions And Operators pg_get_function_resultFunctionsReferencepg_get_function_result System Information Functions And Operators 10 get RETURNS clause for function pg_get_function_result ( func_oid ) → text get RETURNS clause for function 11 get RETURNS…Functions · System Information Functions And Operators pg_get_functiondefFunctionsReferencepg_get_functiondef System Information Functions And Operators 10 get definition of a function pg_get_functiondef ( func_oid ) → text get definition of a function 11 get definition of a funct…Functions · System Information Functions And Operators pg_get_indexdefFunctionsReferencepg_get_indexdef System Information Functions And Operators 10 get CREATE INDEX command for index pg_get_indexdef ( index_oid ) → text get CREATE INDEX command for index pg_get_indexdef ( ind…Functions · System Information Functions And Operators pg_get_keywordsFunctionsReferencepg_get_keywords System Information Functions And Operators 10 get list of SQL keywords and their categories pg_get_keywords ( ) → setof record get list of SQL keywords and their categories 1…Functions · System Information Functions And Operators pg_get_loaded_modulesFunctionsReferencepg_get_loaded_modules System Information Functions And Operators 18 Returns a list of the loadable modules that are loaded into the current server session. The module_name and version fields…Functions · System Information Functions And Operators pg_get_multixact_membersFunctionsReferencepg_get_multixact_members System Information Functions And Operators 13 Returns the transaction ID and lock mode for each member of the specified multixact ID. The lock modes forupd, fornokey…Functions · System Information Functions And Operators pg_get_multixact_statsFunctionsReferencepg_get_multixact_stats System Information Functions And Operators 19 Returns statistics about current multixact usage: num_mxids is the total number of multixact IDs currently present in the…Functions · System Information Functions And Operators pg_get_object_addressFunctionsReferencepg_get_object_address System Information Functions And Operators 10 get address of a database object from its external representation pg_get_object_address ( type text, name text[], args tex…Functions · System Information Functions And Operators pg_get_partition_constraintdefFunctionsReferencepg_get_partition_constraintdef System Information Functions And Operators 14 Reconstructs the definition of a partition constraint. (This is a decompiled reconstruction, not the original tex…Functions · System Information Functions And Operators pg_get_partkeydefFunctionsReferencepg_get_partkeydef System Information Functions And Operators 16 Reconstructs the definition of a partitioned table's partition key, in the form it would have in the PARTITION BY clause of CR…Functions · System Information Functions And Operators pg_get_propgraphdefFunctionsReferencepg_get_propgraphdef System Information Functions And Operators 19 Reconstructs the creating command for a property graph. (This is a decompiled reconstruction, not the original text of the c…Functions · System Information Functions And Operators pg_get_role_ddlFunctionsReferencepg_get_role_ddl System Information Functions And Operators 19 Reconstructs the CREATE ROLE statement and any ALTER ROLE ... SET statements for the given role. Each statement is returned as a…Functions · System Information Functions And Operators pg_get_ruledefFunctionsReferencepg_get_ruledef System Information Functions And Operators 10 get CREATE RULE command for rule pg_get_ruledef ( rule_oid ) → text get CREATE RULE command for rule pg_get_ruledef ( rule_oid, p…Functions · System Information Functions And Operators pg_get_sequence_dataFunctionsReferencepg_get_sequence_data Sequence Manipulation Functions 19 Returns information about the sequence. last_value is the last sequence value written to disk. If caching is used, this value can be g…Functions · Sequence Manipulation Functions pg_get_serial_sequenceFunctionsReferencepg_get_serial_sequence System Information Functions And Operators 10 get name of the sequence that a serial or identity column uses pg_get_serial_sequence ( table_name, column_name ) → text …Functions · System Information Functions And Operators pg_get_statisticsobjdefFunctionsReferencepg_get_statisticsobjdef System Information Functions And Operators 10 get CREATE STATISTICS command for extended statistics object pg_get_statisticsobjdef ( statobj_oid ) → text get CREATE S…Functions · System Information Functions And Operators pg_get_tablespace_ddlFunctionsReferencepg_get_tablespace_ddl System Information Functions And Operators 19 Reconstructs the CREATE TABLESPACE statement for the specified tablespace (by OID or name). If the tablespace has options …Functions · System Information Functions And Operators pg_get_triggerdefFunctionsReferencepg_get_triggerdef System Information Functions And Operators 10 get CREATE [ CONSTRAINT ] TRIGGER command for trigger pg_get_triggerdef ( trigger_oid ) → text get CREATE [ CONSTRAINT ] TRIGG…Functions · System Information Functions And Operators pg_get_userbyidFunctionsReferencepg_get_userbyid System Information Functions And Operators 10 get role name with given OID pg_get_userbyid ( role_oid ) → name get role name with given OID 11 12 13 Returns a role's name giv…Functions · System Information Functions And Operators pg_get_viewdefFunctionsReferencepg_get_viewdef System Information Functions And Operators 10 get underlying SELECT command for view or materialized view (deprecated) pg_get_viewdef ( view_name ) → text get underlying SELEC…Functions · System Information Functions And Operators pg_get_wal_replay_pause_stateFunctionsReferencepg_get_wal_replay_pause_state System Administration Functions 14 Returns recovery pause state. The return values are not paused if pause is not requested, pause requested if pause is request…Functions · System Administration Functions pg_get_wal_resource_managersFunctionsReferencepg_get_wal_resource_managers System Administration Functions 15 Returns the currently-loaded WAL resource managers in the system. The column rm_builtin indicates whether it's a built-in reso…Functions · System Administration Functions pg_get_wal_summarizer_stateFunctionsReferencepg_get_wal_summarizer_state System Information Functions And Operators 17 Returns information about the progress of the WAL summarizer. If the WAL summarizer has never run since the instance…Functions · System Information Functions And Operators pg_has_roleFunctionsReferencepg_has_role System Information Functions And Operators 10 does user have privilege for role pg_has_role ( user, role, privilege ) → boolean does user have privilege for role pg_has_role ( ro…Functions · System Information Functions And Operators pg_identify_objectFunctionsReferencepg_identify_object System Information Functions And Operators 10 get identity of a database object pg_identify_object ( classid oid, objid oid, objsubid integer ) → type text, schema text, n…Functions · System Information Functions And Operators pg_identify_object_as_addressFunctionsReferencepg_identify_object_as_address System Information Functions And Operators 10 get external representation of a database object's address pg_identify_object_as_address ( classid oid, objid oid,…Functions · System Information Functions And Operators pg_import_system_collationsFunctionsReferencepg_import_system_collations System Administration Functions 10 Import operating system collations pg_import_system_collations ( schema regnamespace ) → integer Import operating system collat…Functions · System Administration Functions pg_index_column_has_propertyFunctionsReferencepg_index_column_has_property System Information Functions And Operators 10 test whether an index column has a specified property pg_index_column_has_property ( index_oid, column_no, prop_nam…Functions · System Information Functions And Operators pg_index_has_propertyFunctionsReferencepg_index_has_property System Information Functions And Operators 10 test whether an index has a specified property pg_index_has_property ( index_oid, prop_name ) → boolean test whether an in…Functions · System Information Functions And Operators pg_indexam_has_propertyFunctionsReferencepg_indexam_has_property System Information Functions And Operators 10 test whether an index access method has a specified property pg_indexam_has_property ( am_oid, prop_name ) → boolean tes…Functions · System Information Functions And Operators