Search PostgreSQL documentation

current_timeSQL CommandsPG18current_time → time with time zone Current time of day; see Section 9.9.5 current_time → 14:39:53.662522-05Date/Time Functions and Operators current_timeFunctionsReferencecurrent_time Date/Time Functions And Operators 10 Current time of day; see Section 9.9.4 current_time → time with time zone Current time of day; see Section 9.9.4 CURRENT_TIME(precision) CUR…Functions · Date/Time Functions And Operators current_timestampSQL CommandsPG18current_timestamp → timestamp with time zone Current date and time (start of current transaction); see Section 9.9.5 current_timestamp → 2019-12-23 14:39:53.662522-05Date/Time Functions and Operators current_timestampFunctionsReferencecurrent_timestamp Date/Time Functions And Operators 10 Current date and time (start of current transaction); see Section 9.9.4 current_timestamp → timestamp with time zone Current date and t…Functions · Date/Time Functions And Operators current_userSQL CommandsPG18current_user → name Returns the user name of the current execution context.System Information Functions and Operators › Session Information Functions current_userFunctionsReferencecurrent_user System Information Functions And Operators 10 user name of current execution context current_user → name user name of current execution context 11 12 13 Returns the user name of…Functions · System Information Functions And Operators currvalFunctionsReferencecurrval Sequence Manipulation Functions 10 Return value most recently obtained with nextval for specified sequence currval ( regclass ) → bigint Return value most recently obtained with next…Functions · Sequence Manipulation Functions cursor_to_xmlFunctionsReferencecursor_to_xml Xml Functions 10 The return type of each function is xml. cursor_to_xml(cursor refcursor, count int, nulls boolean, tableforest boolean, targetns text) The return type of each …Functions · Xml Functions cursor_to_xmlschemaFunctionsReferencecursor_to_xmlschema Xml Functions 10 It is essential that the same parameters are passed in order to obtain matching XML data mappings and XML Schema documents. cursor_to_xmlschema(cursor re…Functions · Xml Functions cursor_tuple_fractionConfigurationReferencecursor_tuple_fraction Query Tuning 10 Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved. The default is 0.1. Smaller values of this setting bias the plann…Configuration · Query Tuning CursorsManual ChaptersPG1841.7. Cursors Rather than executing a whole query at once, it is possible to set up a cursor that encapsulates the query, and then read the query result a few rows at a time. One reason for …Cursors Custom Cumulative StatisticsManual ChaptersPG1836.10.15. Custom Cumulative Statistics It is possible for add-ins written in C-language to use custom types of cumulative statistics registered in the Cumulative Statistics System. First, de…Custom Cumulative Statistics Custom Scan Execution CallbacksManual ChaptersPG1860.3.1. Custom Scan Execution Callbacks void (*BeginCustomScan) (CustomScanState *node, EState *estate, int eflags); Complete initialization of the supplied CustomScanState. Standard fields …Custom Scan Execution Callbacks Custom Scan Path CallbacksManual ChaptersPG1860.1.1. Custom Scan Path Callbacks Plan *(*PlanCustomPath) (PlannerInfo *root, RelOptInfo *rel, CustomPath *best_path, List *tlist, List *clauses, List *custom_plans); Convert a custom path …Custom Scan Path Callbacks Custom Scan Plan CallbacksManual ChaptersPG1860.2.1. Custom Scan Plan Callbacks Node *(*CreateCustomScanState) (CustomScan *cscan); Allocate a CustomScanState for this CustomScan. The actual allocation will often be larger than require…Custom Scan Plan Callbacks Custom ScriptsManual ChaptersPG18Custom Scripts pgbench has support for running custom benchmark scenarios by replacing the default transaction script (described above) with a transaction script read from a file (-f option)…Custom Scripts Custom Server SettingsManual ChaptersPG1831.1.5. Custom Server Settings There are several ways to use custom server settings when running a test suite. This can be useful to enable additional logging, adjust resource limits, or ena…Custom Server Settings Custom Wait EventsManual ChaptersPG1836.10.13. Custom Wait Events Add-ins can define custom wait events under the wait event type Extension by calling: uint32 WaitEventExtensionNew(const char *wait_event_name) The wait event is…Custom Wait Events Custom WAL Resource ManagersManual ChaptersPG1864.2. Custom WAL Resource Managers This section explains the interface between the core PostgreSQL system and custom WAL resource managers, which enable extensions to integrate directly with…Custom WAL Resource Managers custom_propertiesExtensionsExtensionsSupabase RLS helper tables and functions for managing user properties and custom claims. claims rls supabase custom_properties SecuritySecurity · Extensions custom_rolesExtensionsExtensionsRole-specific Supabase RLS tables and functions for managing user roles. rls roles supabase garyaustin-custom_roles SecuritySecurity · Extensions custom_variable_classesConfigurationReferencecustom_variable_classes Customized Options 9.0 This variable specifies one or several class names to be used for custom variables, in the form of a comma-separated list. A custom variable is…Configuration · Customized Options Customized OptionsManual ChaptersPG1819.16. Customized Options This feature was designed to allow parameters not normally known to PostgreSQL to be added by add-on modules (such as procedural languages). This allows extension m…Customized Options cyanauditExtensionsExtensionsCyan Audit core extension audit audit log audit logging audit trail auditing cyan audit cyanaudit dml log forensic logging forensics logger logging transaction history trigger-based logging …Security · Extensions Cycle DetectionManual ChaptersPG187.8.2.2. Cycle Detection When working with recursive queries it is important to be sure that the recursive part of the query will eventually return no tuples, or else the query will loop ind…Cycle Detection CygwinManual ChaptersPG1817.7.1. Cygwin PostgreSQL can be built using Cygwin, a Linux-like environment for Windows, but that method is inferior to the native Windows build and running a server under Cygwin is no lon…Cygwin Daitch-Mokotoff SoundexManual ChaptersPG18F.16.2. Daitch-Mokotoff Soundex Like the original Soundex system, Daitch-Mokotoff Soundex matches similar-sounding names by converting them to the same code. However, Daitch-Mokotoff Soundex…Daitch-Mokotoff Soundex dammExtensionsExtensionsSQL implementation of the Damm check digit algorithm with a damm_code domain and helper functions. check-digit damm-algorithm data-type damm Data typesData types · Extensions Data ChecksumsManual ChaptersPG1828.2. Data Checksums By default, data pages are protected by checksums, but this can optionally be disabled for a cluster. When enabled, each data page includes a checksum that is updated wh…Data Checksums Data Consistency Checks at the Application LevelManual ChaptersPG1813.4. Data Consistency Checks at the Application Level It is very difficult to enforce business rules regarding data integrity using Read Committed transactions because the view of the data …Data Consistency Checks at the Application Level Data DefinitionManual ChaptersPG18Chapter 5. Data Definition This chapter covers how one creates the database structures that will hold one's data. In a relational database, the raw data is stored in tables, so the majority …Data Definition Data File FormatManual ChaptersPG1868.2.1. Data File Format Each .dat file contains Perl data structure literals that are simply eval'd to produce an in-memory data structure consisting of an array of hash references, one per…Data File Format Data ManipulationManual ChaptersPG18Chapter 6. Data Manipulation The previous chapter discussed how to create tables and other structures to hold your data. Now it is time to fill the tables with data. This chapter covers how …Data Manipulation Data Type Formatting FunctionsManual ChaptersPG189.8. Data Type Formatting Functions The PostgreSQL formatting functions provide a powerful set of tools for converting various data types (date/time, integer, floating point, numeric) to for…Data Type Formatting Functions Data Type MappingManual ChaptersPG1844.2.1. Data Type Mapping When a PL/Python function is called, its arguments are converted from their PostgreSQL data type to a corresponding Python type: PostgreSQL boolean is converted to …Data Type Mapping Data TypesManual ChaptersPG18Chapter 8. Data Types PostgreSQL has a rich set of native data types available to users. Users can add new types to PostgreSQL using the CREATE TYPE command. Table 8.1 shows all the built-in…Data Types Data TypesManual ChaptersPG1835.2. Data Types The columns of the information schema views use special data types that are defined in the information schema. These are defined as simple domains over ordinary built-in typ…Data Types Data TypesManual ChaptersPG18F.20.1. Data Types Table F.10 shows the data types provided by the isn module. Table F.10. isn Data Types Data Type Description EAN13 European Article Numbers, always displayed in the EAN13 …Data Types Data TypesManual ChaptersPG18E.6.3.3. Data Types Improve Unicode full case mapping and conversion (Jeff Davis) § § This adds the ability to do conditional and title case mapping, and case map single characters to multip…Data Types Data Validity Checking FunctionsManual ChaptersPG189.27.7. Data Validity Checking Functions The functions shown in Table 9.83 can be helpful for checking validity of proposed input data. Table 9.83. Data Validity Checking Functions Function …Data Validity Checking Functions