Search PostgreSQL documentation

NEGATORManual ChaptersPG1836.15.2. NEGATOR The NEGATOR clause, if provided, names an operator that is the negator of the operator being defined. We say that operator A is the negator of operator B if both return Bool…NEGATOR Network Address Functions and OperatorsManual ChaptersPG189.12. Network Address Functions and Operators The IP network address types, cidr and inet, support the usual comparison operators shown in Table 9.1 as well as the specialized operators and …Network Address Functions and Operators Network Address TypesManual ChaptersPG188.9. Network Address Types PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8.21. It is better to use these types instead of plain text types to store n…Network Address Types 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 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 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 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 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 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 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 NotesManual ChaptersPG18Notes psql works best with servers of the same or an older major version. Backslash commands are particularly likely to fail if the server is of a newer version than psql itself. However, ba…Notes NotesManual ChaptersPG18F.5.2. Notes Server crashes may leave temporary files with the prefix archtemp in the archive directory. It is recommended to delete such files before restarting the server after a crash. It…Notes NotesManual ChaptersPG18Notes As of PostgreSQL 9.0, the attribute numbers in primary_key_attnums are interpreted as logical column numbers, corresponding to the column's position in SELECT * FROM relname. Previous …Notes NotesManual ChaptersPG18Notes As of PostgreSQL 9.0, the attribute numbers in primary_key_attnums are interpreted as logical column numbers, corresponding to the column's position in SELECT * FROM relname. Previous …Notes NotesManual ChaptersPG18Notes As of PostgreSQL 9.0, the attribute numbers in primary_key_attnums are interpreted as logical column numbers, corresponding to the column's position in SELECT * FROM relname. Previous …Notes NotesManual ChaptersPG18Notes If dblink_open started an explicit transaction block, and this is the last remaining open cursor in this connection, dblink_close will issue the matching COMMIT.Notes NotesManual ChaptersPG18Notes If untrusted users have access to a database that has not adopted a secure schema usage pattern, begin each session by removing publicly-writable schemas from search_path. One could, f…Notes NotesManual ChaptersPG18Notes When asynchronous queries are initiated by dblink_send_query, the error message associated with the connection might not get updated until the server's response message is consumed. Th…Notes NotesManual ChaptersPG18Notes On a mismatch between the number of return columns specified in the FROM clause, and the actual number of columns returned by the remote cursor, an error will be thrown. In this event,…Notes NotesManual ChaptersPG18Notes A convenient way to use dblink with predetermined queries is to create a view. This allows the column type information to be buried in the view, instead of having to spell it out in ev…Notes NotesManual ChaptersPG18Notes This function must be called if dblink_send_query returned 1. It must be called once for each query sent, and one additional time to obtain an empty set result, before the connection c…Notes