Search PostgreSQL documentation

nfiesta_sdesignExtensionsExtensionsPostgreSQL extension for manipulating sampling design data. postgis sampling-design nfiesta_sdesign Functions and aggregatesFunctions and aggregates · Extensions nfiesta_target_dataExtensionsExtensionsPostgreSQL extension for manipulation of target data - aggregation of local density contributions at the plot level. nfiesta_target_data GeospatialGeospatial · Extensions NFSManual ChaptersPG1818.2.2.1. NFS It is possible to use an NFS file system for storing the PostgreSQL data directory. PostgreSQL does nothing special for NFS file systems, meaning it assumes NFS behaves exactly…NFS nlevelFunctionsPG18nlevel ( ltree ) → integer Returns number of labels in path. nlevel('Top.Child1.Child2') → 3ltree — hierarchical tree-like data type › Operators and Functions No XML(SEQUENCE) TypeManual ChaptersPG18D.3.2.3. No XML(SEQUENCE) Type The PostgreSQL xml data type can only hold a value in DOCUMENT or CONTENT form. An XQuery/XPath expression context item must be a single XML node or atomic val…No XML(SEQUENCE) Type noddlExtensionsExtensionsCluster-wide DDL blocker with role and database exceptions. ddl guard security hook noddl SecuritySecurity · Extensions nominatim_fdwExtensionsExtensionsNominatim Foreign Data Wrapper for PostgreSQL nominatim_fdw Foreign data wrappersForeign data wrappers · Extensions Non-Deferred Uniqueness ConstraintsManual ChaptersPG18Non-Deferred Uniqueness Constraints When a UNIQUE or PRIMARY KEY constraint is not deferrable, PostgreSQL checks for uniqueness immediately whenever a row is inserted or modified. The SQL st…Non-Deferred Uniqueness Constraints Non-Durable SettingsManual ChaptersPG1814.5. Non-Durable Settings Durability is a database feature that guarantees the recording of committed transactions even if the server crashes or loses power. However, durability adds signif…Non-Durable Settings non_truncateExtensionsExtensionsDisables TRUNCATE by raising an error from a ProcessUtility hook ddl guardrail processutility truncate non_truncate AdministrationAdministration · Extensions Nondeterministic CollationsManual ChaptersPG1823.2.2.4. Nondeterministic Collations A collation is either deterministic or nondeterministic. A deterministic collation uses deterministic comparisons, which means that it considers strings…Nondeterministic Collations nonomsExtensionsExtensionsNormalised nomenclatural system for managing biological names and taxonomic understandings in PostgreSQL. biology nomenclature nonoms FeaturesFeatures · Extensions Nonstandard ClausesManual ChaptersPG18Nonstandard Clauses DISTINCT ON ( ... ) is an extension of the SQL standard. ROWS FROM( ... ) is an extension of the SQL standard. The MATERIALIZED and NOT MATERIALIZED options of WITH are e…Nonstandard Clauses norasearchExtensionsExtensionsNoraSearch is a high-performance search engine for PostgreSQL. norasearch Full-text searchFull-text search · Extensions normExtensionsExtensionsNo-ORM helper extension that generates simple CRUD functions. crud orm norm FeaturesFeatures · Extensions normal_randFunctionsPG18normal_rand ( numvals integer, mean float8, stddev float8 ) → setof float8 Produces a set of normally distributed random values.tablefunc — functions that return tables (crosstab and others) › Functions Provided normal_randManual ChaptersPG18F.43.1.1. normal_rand normal_rand(int numvals, float8 mean, float8 stddev) returns setof float8 normal_rand produces a set of normally distributed random values (Gaussian distribution). numv…normal_rand normalizeFunctionsReferencenormalize String Functions And Operators 13 Converts the string to the specified Unicode normalization form. The optional form key word specifies the form: NFC (the default), NFD, NFKC, or N…Functions · String Functions And Operators nosetExtensionsExtensionsModule for blocking SET variables for non-super users. pg_noset SecuritySecurity · Extensions nostr_filterExtensionsExtensionsNostr event types, insertion helpers, and JSON filter evaluation inside PostgreSQL. nostr event filter json nostr_filter FeaturesFeatures · Extensions NOT INSQL CommandsPG189.25.2. NOT IN # expression NOT IN (value [, ...]) The right-hand side is a parenthesized list of expressions. The result is “true” if the left-hand expression's result is unequal to all of …Row and Array Comparisons › NOT IN NOT INManual ChaptersPG189.25.2. NOT IN expression NOT IN (value [, ...]) The right-hand side is a parenthesized list of expressions. The result is “true” if the left-hand expression's result is unequal to all of th…NOT IN NOT INManual ChaptersPG189.24.3. NOT IN expression NOT IN (subquery) The right-hand side is a parenthesized subquery, which must return exactly one column. The left-hand expression is evaluated and compared to each …NOT IN Not-Null ConstraintsManual ChaptersPG185.5.2. Not-Null Constraints A not-null constraint simply specifies that a column must not assume the null value. A syntax example: CREATE TABLE products ( product_no integer NOT NULL, name t…Not-Null Constraints NotesManual ChaptersPG18Notes When compiling the preprocessed C code files, the compiler needs to be able to find the ECPG header files in the PostgreSQL include directory. Therefore, you might have to use the -I o…Notes NotesManual ChaptersPG18Notes initdb can also be invoked via pg_ctl initdb.Notes NotesManual ChaptersPG18Notes Since pg_dumpall calls pg_dump internally, some diagnostic messages will refer to pg_dump. The --clean option can be useful even when your intention is to restore the dump script into …Notes NotesManual ChaptersPG18Notes It is not necessary to supply correct user name, password, or database name values to obtain the server status; however, if incorrect values are provided, the server will log a failed …Notes NotesManual ChaptersPG18Notes pg_amcheck is designed to work with PostgreSQL 14.0 and later.Notes NotesManual ChaptersPG18Notes At the beginning of the backup, a checkpoint needs to be performed on the source server. This can take some time (especially if the option --checkpoint=fast is not used), during which …Notes NotesManual ChaptersPG18Notes Enabling checksums in a large cluster can potentially take a long time. During this operation, the cluster or other programs that write to the data directory must not be started or els…Notes NotesManual ChaptersPG18Notes The options --docdir, --pkgincludedir, --localedir, --mandir, --sharedir, --sysconfdir, --cc, --cppflags, --cflags, --cflags_sl, --ldflags, --ldflags_sl, and --libs were added in Postg…Notes NotesManual ChaptersPG18NotesNotes NotesManual ChaptersPG18Notes If your database cluster has any local additions to the template1 database, be careful to restore the output of pg_dump into a truly empty database; otherwise you are likely to get err…Notes NotesManual ChaptersPG18Notes When using pg_receivewal instead of archive_command or archive_library as the main WAL backup method, it is strongly recommended to use replication slots. Otherwise, the server is free…Notes NotesManual ChaptersPG18Notes pg_recvlogical will preserve group permissions on the output files if group permissions are enabled on the source cluster.Notes NotesManual ChaptersPG18Notes This command must not be used when the server is running. pg_resetwal will refuse to start up if it finds a server lock file in the data directory. If the server crashed then a lock fi…Notes NotesManual ChaptersPG18Notes If your installation has any local additions to the template1 database, be careful to load the output of pg_restore into a truly empty database; otherwise you are likely to get errors …Notes NotesManual ChaptersPG18Notes When executing pg_rewind using an online cluster as source, a role having sufficient permissions to execute the functions used by pg_rewind on the source cluster can be used instead of…Notes NotesManual ChaptersPG18Notes The utility command pg_ctl can be used to start and shut down the postgres server safely and comfortably. If at all possible, do not use SIGKILL to kill the main postgres server. Doing…Notes