Search PostgreSQL documentation

information_schema_catalog_nameManual ChaptersPG1835.3. information_schema_catalog_name information_schema_catalog_name is a table that always contains one row and one column containing the name of the current database (current catalog, in …information_schema_catalog_name Informix Compatibility ModeManual ChaptersPG1834.15. Informix Compatibility Mode ecpg can be run in a so-called Informix compatibility mode. If this mode is active, it tries to behave as if it were the Informix precompiler for Informix …Informix Compatibility Mode Informix-compatible SQLDA Descriptor AreasManual ChaptersPG1834.15.3. Informix-compatible SQLDA Descriptor Areas Informix-compatible mode supports a different structure than the one described in Section 34.7.2. See below: struct sqlvar_compat { short …Informix-compatible SQLDA Descriptor Areas InheritanceManual ChaptersPG185.11. Inheritance PostgreSQL implements table inheritance, which can be a useful tool for database designers. (SQL:1999 and later define a type inheritance feature, which differs in many res…Inheritance InheritanceManual ChaptersPG18Inheritance Multiple inheritance via the INHERITS clause is a PostgreSQL language extension. SQL:1999 and later define single inheritance using a different syntax and different semantics. SQ…Inheritance InheritanceManual ChaptersPG183.6. Inheritance Inheritance is a concept from object-oriented databases. It opens up interesting new possibilities of database design. Let's create two tables: A table cities and a table ca…Inheritance initdbManual ChaptersPG18initdb initdb — create a new PostgreSQL database cluster Synopsis initdb [option...] [ --pgdata | -D ] directoryinitdb Initial Data SynchronizationManual ChaptersPG1829.4.5. Initial Data Synchronization If the subscription requires copying pre-existing table data and a publication contains WHERE clauses, only data that satisfies the row filter expression…Initial Data Synchronization Initial SnapshotManual ChaptersPG1829.9.1. Initial Snapshot The initial data in existing subscribed tables is snapshotted and copied in parallel instances of a special kind of apply process. These special apply processes are …Initial Snapshot Initialization FunctionManual ChaptersPG1847.6.1. Initialization Function An output plugin is loaded by dynamically loading a shared library with the output plugin's name as the library base name. The normal library search path is u…Initialization Function Initialization FunctionsManual ChaptersPG1849.1. Initialization Functions An archive library is loaded by dynamically loading a shared library with the archive_library's name as the library base name. The normal library search path i…Initialization Functions Initialization FunctionsManual ChaptersPG1850.2. Initialization Functions OAuth validator modules are dynamically loaded from the shared libraries listed in oauth_validator_libraries. Modules are loaded on demand when requested from …Initialization Functions Initialization OptionsManual ChaptersPG18Initialization Options pgbench accepts the following command-line initialization arguments: [-d] dbname[--dbname=]dbname # Specifies the name of the database to test in. If this is not speci…Initialization Options Injection PointsManual ChaptersPG1836.10.14. Injection Points An injection point with a given name is declared using macro: INJECTION_POINT(name, arg); There are a few injection points already declared at strategic points wit…Injection Points InliningManual ChaptersPG1830.1.2. Inlining PostgreSQL is very extensible and allows new data types, functions, operators and other database objects to be defined; see Chapter 36. In fact the built-in objects are impl…Inlining Inlining Support for ExtensionsManual ChaptersPG1830.4.1. Inlining Support for Extensions PostgreSQL's JIT implementation can inline the bodies of functions of types C and internal, as well as operators based on such functions. To do so for…Inlining Support for Extensions INSERTManual ChaptersPG18INSERT INSERT — create new rows in a table Synopsis [ WITH [ RECURSIVE ] with_query [, ...] ] INSERT INTO table_name [ AS alias ] [ ( column_name [, ...] ) ] [ OVERRIDING { SYSTEM | USER } V…INSERT insert_username — Functions for Tracking Who Changed a TableManual ChaptersPG18F.41.3. insert_username — Functions for Tracking Who Changed a Table insert_username() is a trigger that stores the current user's name into a text field. This can be useful for tracking who…insert_username — Functions for Tracking Who Changed a Table InsertingManual ChaptersPG18Inserting This section covers parameters that may be used when only inserting new rows. Parameters exclusively used with the ON CONFLICT clause are described separately. with_query The WITH …Inserting Inserting DataManual ChaptersPG186.1. Inserting Data When a table is created, it contains no data. The first thing to do before a database can be of much use is to insert data. Data is inserted one row at a time. You can al…Inserting Data Inspecting MCV ListsManual ChaptersPG189.31.1. Inspecting MCV Lists pg_mcv_list_items ( pg_mcv_list ) → setof record pg_mcv_list_items returns a set of records describing all items stored in a multi-column MCV list. It returns th…Inspecting MCV Lists InstallationManual ChaptersPG18F.40.2. Installation sepgsql can only be used on Linux 2.6.28 or higher with SELinux enabled. It is not available on any other platform. You will also need libselinux 2.1.10 or higher and se…Installation InstallationManual ChaptersPG181.1. Installation Before you can use PostgreSQL you need to install it, of course. It is possible that PostgreSQL is already installed at your site, either because it was included in your op…Installation Installation from BinariesManual ChaptersPG18Chapter 16. Installation from Binaries PostgreSQL is available in the form of binary packages for most common operating systems today. When available, this is the recommended way to install …Installation from Binaries Installation from Source CodeManual ChaptersPG18Chapter 17. Installation from Source Code This chapter describes the installation of PostgreSQL using the source code distribution. If you are installing a pre-packaged distribution, such as…Installation from Source Code Installation LocationsManual ChaptersPG1817.3.3.1. Installation Locations These options control where make install will put the files. The --prefix option is sufficient for most cases. If you have special needs, you can customize t…Installation Locations Installation LocationsManual ChaptersPG1817.4.3.1. Installation Locations These options control where ninja install (or meson install) will put the files. The --prefix option (example Section 17.4.1) is sufficient for most cases. I…Installation Locations Installation on Fedora, RHEL, and DerivativesManual ChaptersPG18J.2.1. Installation on Fedora, RHEL, and Derivatives To install the required packages, use: yum install docbook-dtds docbook-style-xsl libxslt fopInstallation on Fedora, RHEL, and Derivatives Installation on FreeBSDManual ChaptersPG18J.2.2. Installation on FreeBSD To install the required packages with pkg, use: pkg install docbook-xml docbook-xsl libxslt fop When building the documentation from the doc directory you'll n…Installation on FreeBSD Installation ProcedureManual ChaptersPG1817.3.2. Installation Procedure Configuration The first step of the installation procedure is to configure the source tree for your system and choose the options you would like. This is done …Installation Procedure Installation ProcedureManual ChaptersPG1817.4.2. Installation Procedure Configuration The first step of the installation procedure is to configure the build tree for your system and choose the options you would like. To create and …Installation Procedure Installation TargetsManual ChaptersPG1817.4.4.4. Installation Targets install # Install postgres, excluding documentation install-docs # Install documentation in multi-page HTML and man page formats install-html # Install documen…Installation Targets Installing Extensions Using Update ScriptsManual ChaptersPG1836.17.5. Installing Extensions Using Update Scripts An extension that has been around for awhile will probably exist in several versions, for which the author will need to write update scrip…Installing Extensions Using Update Scripts Installing Procedural LanguagesManual ChaptersPG1840.1. Installing Procedural Languages A procedural language must be “installed” into each database where it is to be used. But procedural languages installed in the database template1 are au…Installing Procedural Languages Insufficient Stack DepthManual ChaptersPG1831.2.6. Insufficient Stack Depth If the errors test results in a server crash at the select infinite_recurse() command, it means that the platform's limit on process stack size is smaller th…Insufficient Stack Depth intagg — integer aggregator and enumeratorManual ChaptersPG18F.18. intagg — integer aggregator and enumerator The intagg module provides an integer aggregator and an enumerator. intagg is now obsolete, because there are built-in functions that provide…intagg — integer aggregator and enumerator intarray Functions and OperatorsManual ChaptersPG18F.19.1. intarray Functions and Operators The functions provided by the intarray module are shown in Table F.8, the operators in Table F.9. Table F.8. intarray Functions Function Description …intarray Functions and Operators intarray — manipulate arrays of integersManual ChaptersPG18F.19. intarray — manipulate arrays of integers The intarray module provides a number of useful functions and operators for manipulating null-free arrays of integers. There is also support fo…intarray — manipulate arrays of integers Integer TypesManual ChaptersPG188.1.1. Integer Types The types smallint, integer, and bigint store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the a…Integer Types Interface FunctionsManual ChaptersPG1845.1. Interface FunctionsInterface Functions