Search PostgreSQL documentation

pg_clear_extended_statsFunctionsReferencepg_clear_extended_stats System Administration Functions 19 Clears data of an extended statistics object, as though the object was newly-created. The required arguments are schemaname and rel…Functions · System Administration Functions pg_clear_relation_statsFunctionsReferencepg_clear_relation_stats System Administration Functions 18 Clears table-level statistics for the given relation, as though the table was newly created. pg_clear_relation_stats ( schemaname t…Functions · System Administration Functions pg_client_encodingFunctionsReferencepg_client_encoding String Functions And Operators 10 Current client encoding name pg_client_encoding ( ) → name Current client encoding name 11 12 13 Returns current client encoding name. pg…Functions · String Functions And Operators pg_collation_actual_versionFunctionsReferencepg_collation_actual_version System Administration Functions 10 Return actual version of collation from operating system pg_collation_actual_version ( oid ) → text Return actual version of co…Functions · System Administration Functions pg_collation_is_visibleFunctionsReferencepg_collation_is_visible System Information Functions And Operators 10 is collation visible in search path pg_collation_is_visible ( collation_oid ) → boolean is collation visible in search p…Functions · System Information Functions And Operators pg_column_compressionFunctionsReferencepg_column_compression System Administration Functions 14 Shows the compression algorithm that was used to compress an individual variable-length value. Returns NULL if the value is not compr…Functions · System Administration Functions pg_column_sizeFunctionsReferencepg_column_size System Administration Functions 10 Number of bytes used to store a particular value (possibly compressed) pg_column_size ( any ) → int Number of bytes used to store a particul…Functions · System Administration Functions pg_column_toast_chunk_idFunctionsReferencepg_column_toast_chunk_id System Administration Functions 17 Shows the chunk_id of an on-disk TOASTed value. Returns NULL if the value is un-TOASTed or not on-disk. See Section 65.2 for more …Functions · System Administration Functions pg_conf_load_timeFunctionsReferencepg_conf_load_time System Information Functions And Operators 10 configuration load time pg_conf_load_time ( ) → timestamp with time zone configuration load time 11 12 13 Returns the time whe…Functions · System Information Functions And Operators pg_control_checkpointFunctionsReferencepg_control_checkpoint System Information Functions And Operators 10 Returns information about current checkpoint state. pg_control_checkpoint ( ) → record Returns information about current c…Functions · System Information Functions And Operators pg_control_initFunctionsReferencepg_control_init System Information Functions And Operators 10 Returns information about cluster initialization state. pg_control_init ( ) → record Returns information about cluster initializ…Functions · System Information Functions And Operators pg_control_recoveryFunctionsReferencepg_control_recovery System Information Functions And Operators 10 Returns information about recovery state. pg_control_recovery ( ) → record Returns information about recovery state. 11 12 1…Functions · System Information Functions And Operators pg_control_systemFunctionsReferencepg_control_system System Information Functions And Operators 10 Returns information about current control file state. pg_control_system ( ) → record Returns information about current control…Functions · System Information Functions And Operators pg_conversion_is_visibleFunctionsReferencepg_conversion_is_visible System Information Functions And Operators 10 is conversion visible in search path pg_conversion_is_visible ( conversion_oid ) → boolean is conversion visible in sea…Functions · System Information Functions And Operators pg_copy_logical_replication_slotFunctionsReferencepg_copy_logical_replication_slot System Administration Functions 12 Copies an existing logical replication slot named src_slot_name to a logical replication slot named dst_slot_name while ch…Functions · System Administration Functions pg_copy_physical_replication_slotFunctionsReferencepg_copy_physical_replication_slot System Administration Functions 12 Copies an existing physical replication slot named src_slot_name to a physical replication slot named dst_slot_name. The …Functions · System Administration Functions pg_create_logical_replication_slotFunctionsReferencepg_create_logical_replication_slot System Administration Functions 10 Creates a new logical (decoding) replication slot named slot_name using the output plugin plugin. The optional third par…Functions · System Administration Functions pg_create_physical_replication_slotFunctionsReferencepg_create_physical_replication_slot System Administration Functions 10 Creates a new physical replication slot named slot_name. The optional second parameter, when true, specifies that the L…Functions · System Administration Functions pg_create_restore_pointFunctionsReferencepg_create_restore_point System Administration Functions 10 Create a named point for performing restore (restricted to superusers by default, but other users can be granted EXECUTE to run the…Functions · System Administration Functions pg_current_logfileFunctionsReferencepg_current_logfile System Information Functions And Operators 10 Primary log file name, or log in the requested format, currently in use by the logging collector pg_current_logfile ( [text] …Functions · System Information Functions And Operators pg_current_snapshotFunctionsReferencepg_current_snapshot System Information Functions And Operators 13 Returns a current snapshot, a data structure showing which transaction IDs are now in-progress. pg_current_snapshot () → pg_…Functions · System Information Functions And Operators pg_current_wal_flush_lsnFunctionsReferencepg_current_wal_flush_lsn System Administration Functions 10 Get current write-ahead log flush location pg_current_wal_flush_lsn ( ) → pg_lsn Get current write-ahead log flush location 11 12 …Functions · System Administration Functions pg_current_wal_insert_lsnFunctionsReferencepg_current_wal_insert_lsn System Administration Functions 10 Get current write-ahead log insert location pg_current_wal_insert_lsn ( ) → pg_lsn Get current write-ahead log insert location 11…Functions · System Administration Functions pg_current_wal_lsnFunctionsReferencepg_current_wal_lsn System Administration Functions 10 Get current write-ahead log write location pg_current_wal_lsn ( ) → pg_lsn Get current write-ahead log write location 11 12 13 Returns t…Functions · System Administration Functions pg_current_xact_idFunctionsReferencepg_current_xact_id System Information Functions And Operators 13 Returns the current transaction's ID. It will assign a new one if the current transaction does not have one already (because …Functions · System Information Functions And Operators pg_current_xact_id_if_assignedFunctionsReferencepg_current_xact_id_if_assigned System Information Functions And Operators 13 Returns the current transaction's ID, or NULL if no ID is assigned yet. (It's best to use this variant if the tra…Functions · System Information Functions And Operators pg_current_xlog_flush_locationFunctionsReferencepg_current_xlog_flush_location System Administration Functions 9.6 Get current transaction log flush location pg_current_xlog_flush_location ( ) → pg_lsn Get current transaction log flush lo…Functions · System Administration Functions pg_current_xlog_insert_locationFunctionsReferencepg_current_xlog_insert_location System Administration Functions 9.0 Get current transaction log insert location pg_current_xlog_insert_location ( ) → text Get current transaction log insert …Functions · System Administration Functions pg_current_xlog_locationFunctionsReferencepg_current_xlog_location System Administration Functions 9.0 Get current transaction log write location pg_current_xlog_location ( ) → text Get current transaction log write location 9.1 9.2…Functions · System Administration Functions pg_database_collation_actual_versionFunctionsReferencepg_database_collation_actual_version System Administration Functions 15 Returns the actual version of the database's collation as it is currently installed in the operating system. If this i…Functions · System Administration Functions pg_database_sizeFunctionsReferencepg_database_size System Administration Functions 10 Disk space used by the database with the specified OID pg_database_size ( oid ) → bigint Disk space used by the database with the specifie…Functions · System Administration Functions pg_describe_objectFunctionsReferencepg_describe_object System Information Functions And Operators 10 get description of a database object pg_describe_object ( classid oid, objid oid, objsubid integer ) → text get description o…Functions · System Information Functions And Operators pg_disable_data_checksumsFunctionsReferencepg_disable_data_checksums System Administration Functions 19 Disables data checksum calculation and validation for the cluster. This will set the data checksum state to inprogress-off while …Functions · System Administration Functions pg_drop_replication_slotFunctionsReferencepg_drop_replication_slot System Administration Functions 10 Drops the physical or logical replication slot named slot_name. Same as replication protocol command DROP_REPLICATION_SLOT. For lo…Functions · System Administration Functions pg_enable_data_checksumsFunctionsReferencepg_enable_data_checksums System Administration Functions 19 Initiates the process of enabling data checksums for the cluster. This will set the data checksums state to inprogress-on as well …Functions · System Administration Functions pg_encoding_to_charFunctionsReferencepg_encoding_to_char System Information Functions And Operators 15 Converts the integer used as the internal identifier of an encoding in some system catalog tables into a human-readable stri…Functions · System Information Functions And Operators pg_event_trigger_ddl_commandsFunctionsReferencepg_event_trigger_ddl_commands Event Trigger Functions 10 pg_event_trigger_ddl_commands returns a list of DDL commands executed by each user action, when invoked in a function attached to a d…Functions · Event Trigger Functions pg_event_trigger_dropped_objectsFunctionsReferencepg_event_trigger_dropped_objects Event Trigger Functions 10 pg_event_trigger_dropped_objects returns a list of all objects dropped by the command in whose sql_drop event it is called. If cal…Functions · Event Trigger Functions pg_event_trigger_table_rewrite_oidFunctionsReferencepg_event_trigger_table_rewrite_oid Event Trigger Functions 10 The OID of the table about to be rewritten. pg_event_trigger_table_rewrite_oid ( ) → Oid The OID of the table about to be rewrit…Functions · Event Trigger Functions pg_event_trigger_table_rewrite_reasonFunctionsReferencepg_event_trigger_table_rewrite_reason Event Trigger Functions 10 The reason code(s) explaining the reason for rewriting. The exact meaning of the codes is release dependent. pg_event_trigger…Functions · Event Trigger Functions