Search PostgreSQL documentation

IndexingManual ChaptersPG188.17.9. Indexing GiST and SP-GiST indexes can be created for table columns of range types. GiST indexes can be also created for table columns of multirange types. For instance, to create a G…Indexing IndicatorsManual ChaptersPG1834.4.6. Indicators The examples above do not handle null values. In fact, the retrieval examples will raise an error if they fetch a null value from the database. To be able to pass null val…Indicators inetManual ChaptersPG188.9.1. inet The inet type holds an IPv4 or IPv6 host address, and optionally its subnet, all in one field. The subnet is represented by the number of network address bits present in the host…inet inetData TypesPG18inet IPv4 or IPv6 host addressData Types inet vs. cidrManual ChaptersPG188.9.3. inet vs. cidr The essential difference between inet and cidr data types is that inet accepts values with nonzero bits to the right of the netmask, whereas cidr does not. For example, …inet vs. cidr inet_client_addrFunctionsReferenceinet_client_addr System Information Functions And Operators 10 address of the remote connection inet_client_addr ( ) → inet address of the remote connection 11 12 13 Returns the IP address o…Functions · System Information Functions And Operators inet_client_portFunctionsReferenceinet_client_port System Information Functions And Operators 10 port of the remote connection inet_client_port ( ) → int port of the remote connection 11 12 13 Returns the IP port number of t…Functions · System Information Functions And Operators inet_mergeFunctionsReferenceinet_merge Network Address Functions And Operators 10 the smallest network which includes both of the given networks inet_merge ( inet, inet ) → cidr the smallest network which includes both…Functions · Network Address Functions And Operators inet_same_familyFunctionsReferenceinet_same_family Network Address Functions And Operators 10 are the addresses from the same family? inet_same_family ( inet, inet ) → boolean are the addresses from the same family? 11 12 13…Functions · Network Address Functions And Operators inet_server_addrFunctionsReferenceinet_server_addr System Information Functions And Operators 10 address of the local connection inet_server_addr ( ) → inet address of the local connection 11 12 13 Returns the IP address on …Functions · System Information Functions And Operators inet_server_portFunctionsReferenceinet_server_port System Information Functions And Operators 10 port of the local connection inet_server_port ( ) → int port of the local connection 11 12 13 Returns the IP port number on whi…Functions · System Information Functions And Operators inetrangeExtensionsExtensionsRange type for PostgreSQL inet values with range operators and GiST indexing support. inet ip networking range inetrange Data typesData types · Extensions Infinite (Unbounded) RangesManual ChaptersPG188.17.4. Infinite (Unbounded) Ranges The lower bound of a range can be omitted, meaning that all values less than the upper bound are included in the range, e.g., (,3]. Likewise, if the upper…Infinite (Unbounded) Ranges influxdb_fdwExtensionsExtensionsForeign data wrapper for querying InfluxDB from PostgreSQL. fdw influxdb time-series influxdb_fdw Foreign data wrappersForeign data wrappers · Extensions 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 informix_fdwExtensionsExtensionsForeign data wrapper for Informix access non-free informix_fdw Foreign data wrappersForeign data wrappers · Extensions 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 initcapFunctionsReferenceinitcap String Functions And Operators 10 Convert the first letter of each word to upper case and the rest to lower case. Words are sequences of alphanumeric characters separated by non-alph…Functions · String Functions And Operators initdbCommand-line ToolsPG18initdb initdb — create a new PostgreSQL database cluster Synopsis initdb [option...] [ --pgdata | -D ] directoryinitdb initdbManual ChaptersPG18initdb initdb — create a new PostgreSQL database cluster Synopsis initdb [option...] [ --pgdata | -D ] directoryinitdb initdb --allow-group-accessCommand-line ToolsPG18-g--allow-group-access Allows users in the same group as the cluster owner to read all cluster files created by initdb. This option is ignored on Windows as it does not support POSIX-style g…initdb › Options initdb --auth-host=authmethodCommand-line ToolsPG18--auth-host=authmethod This option specifies the authentication method for local users via TCP/IP connections used in pg_hba.conf (host lines).initdb › Options initdb --auth-local=authmethodCommand-line ToolsPG18--auth-local=authmethod This option specifies the authentication method for local users via Unix-domain socket connections used in pg_hba.conf (local lines).initdb › Options initdb --auth=authmethodCommand-line ToolsPG18-A authmethod--auth=authmethod This option specifies the default authentication method for local users used in pg_hba.conf (host and local lines). See Section 20.1 for an overview of valid v…initdb › Options initdb --builtin-locale=localeCommand-line ToolsPG18--builtin-locale=locale Specifies the locale name when the builtin provider is used. Locale support is described in Section 23.1.initdb › Options initdb --data-checksumsCommand-line ToolsPG18-k--data-checksums Use checksums on data pages to help detect corruption by the I/O system that would otherwise be silent. This is enabled by default; use --no-data-checksums to disable chec…initdb › Options initdb --debugCommand-line ToolsPG18-d--debug Print debugging output from the bootstrap backend and a few other messages of lesser interest for the general public. The bootstrap backend is the program initdb uses to create the…initdb › Options initdb --discard-cachesCommand-line ToolsPG18--discard-caches Run the bootstrap backend with the debug_discard_caches=1 option. This takes a very long time and is only of use for deep debugging.initdb › Options initdb --encoding=encodingCommand-line ToolsPG18-E encoding--encoding=encoding Selects the encoding of the template databases. This will also be the default encoding of any database you create later, unless you override it then. The chara…initdb › Options initdb --helpCommand-line ToolsPG18-?--help Show help about initdb command line arguments, and exit.initdb › Options initdb --icu-locale=localeCommand-line ToolsPG18--icu-locale=locale Specifies the ICU locale when the ICU provider is used. Locale support is described in Section 23.1.initdb › Options initdb --icu-rules=rulesCommand-line ToolsPG18--icu-rules=rules Specifies additional collation rules to customize the behavior of the default collation. This is supported for ICU only.initdb › Options initdb --lc-time=localeCommand-line ToolsPG18--lc-collate=locale--lc-ctype=locale--lc-messages=locale--lc-monetary=locale--lc-numeric=locale--lc-time=locale Like --locale, but only sets the locale in the specified category.initdb › Options initdb --locale-provider={builtin|libc|icu}Command-line ToolsPG18--locale-provider={builtin|libc|icu} This option sets the locale provider for databases created in the new cluster. It can be overridden in the CREATE DATABASE command when new databases are…initdb › Options initdb --locale=localeCommand-line ToolsPG18--locale=locale Sets the default locale for the database cluster. If this option is not specified, the locale is inherited from the environment that initdb runs in. Locale support is describ…initdb › Options initdb --no-cleanCommand-line ToolsPG18-n--no-clean By default, when initdb determines that an error prevented it from completely creating the database cluster, it removes any files it might have created before discovering that i…initdb › Options