Search PostgreSQL documentation

crosstab(text)Manual ChaptersPG18F.43.1.2. crosstab(text) crosstab(text sql) crosstab(text sql, int N) The crosstab function is used to produce “pivot” displays, wherein data is listed across the page rather than down. For …crosstab(text) crosstab(text, text)Manual ChaptersPG18F.43.1.4. crosstab(text, text) crosstab(text source_sql, text category_sql) The main limitation of the single-parameter form of crosstab is that it treats all values in a group alike, insert…crosstab(text, text) crosstabNFunctionsPG18crosstabN ( sql text ) → setof table_crosstab_N Produces a “pivot table” containing row names plus N value columns. crosstab2, crosstab3, and crosstab4 are predefined, but you can create add…tablefunc — functions that return tables (crosstab and others) › Functions Provided crosstabN(text)Manual ChaptersPG18F.43.1.3. crosstabN(text) crosstabN(text sql) The crosstabN functions are examples of how to set up custom wrappers for the general crosstab function, so that you need not write out column n…crosstabN(text) crunchy_poolerExtensionsExtensionsCrunchy Bridge helper extension that lets PgBouncer authenticate users through PostgreSQL. authentication pgbouncer pooling crunchy_pooler SecuritySecurity · Extensions crypt()Manual ChaptersPG18F.26.2.1. crypt() crypt(password text, salt text) returns text Calculates a crypt(3)-style hash of password. When storing a new password, you need to use gen_salt() to generate a new salt va…crypt() cryptintExtensionsExtensionsEncryption functions for int and bigint values cryptint UtilitiesUtilities · Extensions cstore_fdwExtensionsExtensionsColumnar storage extension for PostgreSQL built as a foreign data wrapper columnar-storage compression fdw olap cstore_fdw AnalyticsAnalytics · Extensions cstringData TypesPG18cstring Indicates that a function accepts or returns a null-terminated C string.Pseudo-Types CSV FormatManual ChaptersPG18CSV Format This format option is used for importing and exporting the Comma- Separated Value (CSV) file format used by many other programs, such as spreadsheets. Instead of the escaping rule…CSV Format csv_tamExtensionsExtensionsCSV table access method for PostgreSQL that stores table tuples in CSV-formatted relation files. csv table-access-method csv_tam FeaturesFeatures · Extensions ctidscanExtensionsExtensionsExample custom scan provider for CTID range predicates. custom-scan planner ctidscan FeaturesFeatures · Extensions cubeFunctionsPG18cube ( float8 ) → cube Makes a one dimensional cube with both coordinates the same. cube(1) → (1)cube — a multi-dimensional cube data type › Usage cubeExtensionsPG18F.10. cube — a multi-dimensional cube data type This module implements a data type cube for representing multidimensional cubes. This module is considered “trusted”, that is, it can be insta…cube — a multi-dimensional cube data type CUBESQL CommandsPG187.2.4. GROUPING SETS, CUBE, and ROLLUP # More complex grouping operations than those described above are possible using the concept of grouping sets. The data selected by the FROM and WHERE …Table Expressions › GROUPING SETS, CUBE, and ROLLUP cube — a multi-dimensional cube data typeManual ChaptersPG18F.10. cube — a multi-dimensional cube data type This module implements a data type cube for representing multidimensional cubes. This module is considered “trusted”, that is, it can be insta…cube — a multi-dimensional cube data type Cube-Based Earth DistancesManual ChaptersPG18F.14.1. Cube-Based Earth Distances Data is stored in cubes that are points (both corners are the same) using 3 coordinates representing the x, y, and z distance from the center of the Earth.…Cube-Based Earth Distances cube_dimFunctionsPG18cube_dim ( cube ) → integer Returns the number of dimensions of the cube. cube_dim('(1,2),(3,4)') → 2cube — a multi-dimensional cube data type › Usage cube_distanceFunctionsPG18cube_distance ( cube, cube ) → float8 Returns the distance between two cubes. If both cubes are points, this is the normal distance function. cube_distance('(1,2)', '(3,4)') → 2.828427124746…cube — a multi-dimensional cube data type › Usage cube_enlargeFunctionsPG18cube_enlarge ( c cube, r double, n integer ) → cube Increases the size of the cube by the specified radius r in at least n dimensions. If the radius is negative the cube is shrunk instead. A…cube — a multi-dimensional cube data type › Usage cube_interFunctionsPG18cube_inter ( cube, cube ) → cube Produces the intersection of two cubes. cube_inter('(1,2)', '(3,4)') → (3, 4),(1, 2)cube — a multi-dimensional cube data type › Usage cube_is_pointFunctionsPG18cube_is_point ( cube ) → boolean Returns true if the cube is a point, that is, the two defining corners are the same. cube_is_point(cube(1,1)) → tcube — a multi-dimensional cube data type › Usage cube_ll_coordFunctionsPG18cube_ll_coord ( cube, integer ) → float8 Returns the n-th coordinate value for the lower left corner of the cube. cube_ll_coord('(1,2),(3,4)', 2) → 2cube — a multi-dimensional cube data type › Usage cube_subsetFunctionsPG18cube_subset ( cube, integer[] ) → cube Makes a new cube from an existing cube, using a list of dimension indexes from an array. Can be used to extract the endpoints of a single dimension, or…cube — a multi-dimensional cube data type › Usage cube_unionFunctionsPG18cube_union ( cube, cube ) → cube Produces the union of two cubes. cube_union('(1,2)', '(3,4)') → (1, 2),(3, 4)cube — a multi-dimensional cube data type › Usage cube_ur_coordFunctionsPG18cube_ur_coord ( cube, integer ) → float8 Returns the n-th coordinate value for the upper right corner of the cube. cube_ur_coord('(1,2),(3,4)', 2) → 4cube — a multi-dimensional cube data type › Usage cume_distFunctionsReferencecume_dist Aggregate Functions 10 relative rank of the hypothetical row, ranging from 1/N to 1 cume_dist ( args ) WITHIN GROUP (ORDER BY sorted_args) → double precision relative rank of the h…Functions · Aggregate Functions Cumulative Query and Index StatisticsManual ChaptersPG1819.9.1. Cumulative Query and Index Statistics These parameters control the server-wide cumulative statistics system. When enabled, the data that is collected can be accessed via the pg_stat …Cumulative Query and Index Statistics currencyExtensionsExtensionsCustom PostgreSQL currency type in 1Byte pg_currency Data typesData types · Extensions Current Date/TimeManual ChaptersPG189.9.5. Current Date/Time PostgreSQL provides a number of functions that return values related to the current date and time. These SQL-standard functions all return values based on the start …Current Date/Time current_catalogFunctionsReferencecurrent_catalog System Information Functions And Operators 10 name of current database (called “catalog” in the SQL standard) current_catalog → name name of current database (called “catalog…Functions · System Information Functions And Operators current_databaseFunctionsReferencecurrent_database System Information Functions And Operators 10 name of current database current_database ( ) → name name of current database 11 12 13 Returns the name of the current database…Functions · System Information Functions And Operators current_dateSQL CommandsPG18current_date → date Current date; see Section 9.9.5 current_date → 2019-12-23Date/Time Functions and Operators current_dateFunctionsReferencecurrent_date Date/Time Functions And Operators 10 Current date; see Section 9.9.4 current_date → date Current date; see Section 9.9.4 11 12 13 14 Current date; see Section 9.9.5 current_date…Functions · Date/Time Functions And Operators current_queryFunctionsReferencecurrent_query System Information Functions And Operators 10 text of the currently executing query, as submitted by the client (might contain more than one statement) current_query ( ) → text…Functions · System Information Functions And Operators current_roleSQL CommandsPG18current_role → name This is equivalent to current_user.System Information Functions and Operators › Session Information Functions current_roleFunctionsReferencecurrent_role System Information Functions And Operators 10 equivalent to current_user current_role → name equivalent to current_user 11 12 13 This is equivalent to current_user. current_role…Functions · System Information Functions And Operators current_schemaFunctionsReferencecurrent_schema System Information Functions And Operators 10 name of current schema current_schema → name name of current schema 11 12 13 Returns the name of the schema that is first in the …Functions · System Information Functions And Operators current_schemasFunctionsReferencecurrent_schemas System Information Functions And Operators 10 names of schemas in search path, optionally including implicit schemas current_schemas ( boolean ) → name[] names of schemas in …Functions · System Information Functions And Operators current_settingFunctionsReferencecurrent_setting System Administration Functions 10 get current value of setting current_setting ( setting_name [, missing_ok ] ) → text get current value of setting 11 12 13 Returns the curr…Functions · System Administration Functions