Search PostgreSQL documentation

ltreeExtensionsPG18ltree — hierarchical tree-like data typehierarchical tree-like data type This module implements a data type ltree for representing labels of data stored in a hierarchical tree-like structure. Extensive facilities for searching thr… ltree — hierarchical tree-like data typeManual ChaptersPG18This module implements a data type ltree for representing labels of data stored in a hierarchical tree-like structure. Extensive facilities for searching through label trees are provided. Th… ltree2textFunctionsPG18ltree — hierarchical tree-like data type › Operators and Functions( ltree ) → text Casts ltree to text. ltree_plpython2uExtensionsExtensionsProcedural languages · ExtensionsA fixed postgres xl so it can compile on newer versions of GCC and glibc ltree_plpython2u Procedural languages ltree_plpython3uExtensionsExtensionsProcedural languages · Extensionstransform between ltree and plpython3u plpython3u Procedural languages ltree_plpythonuExtensionsExtensionsProcedural languages · Extensionstransform between ltree and plpythonu ltree_plpythonu Procedural languages ltree_plrubyExtensionsExtensionsProcedural languages · ExtensionsTransform between ltree and Ruby Arrays for PL/Ruby ltree ruby transform plruby Procedural languages lua_fdwExtensionsExtensionsForeign data wrappers · ExtensionsLua Foreign Data Wrapper fdw lua read-only lua_fdw Foreign data wrappers ludia_funcsExtensionsExtensionsFull-text search · ExtensionsLudia full-text search helper functions fts japanese normalization snippet ludia_funcs Full-text search lukasiewicz_logicExtensionsExtensionsFunctions and aggregates · ExtensionsProvides operators to evaluate fuzzy logic expressions according to Łukasiewicz logic. fuzzy gödel logic operators product łukasiewicz fuzzy_logic Functions and aggregates LWLocksManual ChaptersPG18C-Language Functions ly2pgExtensionsExtensionsReplication and streams · ExtensionsImport LilyPond files into PostgreSQL dependency-closure ly2pg source-only sql pgwtc Replication and streams macaddrManual ChaptersPG18Network Address TypesThe macaddr type stores MAC addresses, known for example from Ethernet card hardware addresses (although MAC addresses are used for other purposes as well). Input is accepted in the followin… macaddr8Manual ChaptersPG18Network Address TypesThe macaddr8 type stores MAC addresses in EUI-64 format, known for example from Ethernet card hardware addresses (although MAC addresses are used for other purposes as well). This type can a… macavityExtensionsExtensionsAdministration · ExtensionsDeterministic session-local fault injection for PostgreSQL test clusters test fault-injection macavity Administration macOSManual ChaptersPG18Tool SetsIf you use MacPorts, the following will get you set up: sudo port install docbook-xml docbook-xsl-nons libxslt fop If you use Homebrew, use this: brew install docbook docbook-xsl libxslt fop… macOSManual ChaptersPG18Platform-Specific NotesTo build PostgreSQL from source on macOS, you will need to install Apple's command line developer tools, which can be done by issuing xcode-select --install (note that this will pop up a GUI… madlibExtensionsExtensionsAI and vectors · ExtensionsAn open-source in-database analytics library analytics machine learning madlib AI and vectors mageExtensionsExtensionsFeatures · ExtensionsYugabyteDB - the cloud native distributed SQL database for mission-critical applications. cloud-native cpp database distributed-database distributed-sql distributed-sql-database high-perform… Main FunctionsManual ChaptersPG18Command Execution FunctionsPQexec # Submits a command to the server and waits for the result. PGresult *PQexec(PGconn *conn, const char *command); Returns a PGresult pointer or possibly a null pointer. A non-null poin… Maintenance for Inheritance PartitioningManual ChaptersPG18Table PartitioningTo remove old data quickly, simply drop the child table that is no longer necessary: DROP TABLE measurement_y2006m02; To remove the child table from the inheritance hierarchy table but retai… Major VersionsManual ChaptersPG18C-Language FunctionsThere is no promise of API compatibility between PostgreSQL major versions. Extension code therefore might require source code changes to work with multiple major versions. These can usually… Major VersionsManual ChaptersPG18C-Language FunctionsServers of different major versions have intentionally incompatible ABIs. Extensions that use server APIs must therefore be re-compiled for each major release. The inclusion of PG_MODULE_MAG… make_validFunctionsPG18isn — data types for international standard numbers (ISBN, EAN, UPC, etc.) › Functions and Operators( isn ) → isn Clears the invalid-check-digit flag of the value. Making a Base BackupManual ChaptersPG18Continuous Archiving and Point-in-Time Recovery (PITR)The easiest way to perform a base backup is to use the pg_basebackup tool. It can create a base backup either as regular files or as a tar archive. If more flexibility than pg_basebackup can… Making a Base Backup Using the Low Level APIManual ChaptersPG18Continuous Archiving and Point-in-Time Recovery (PITR)Instead of taking a full or incremental base backup using pg_basebackup, you can take a base backup using the low-level API. This procedure contains a few more steps than the pg_basebackup m… Making an Incremental BackupManual ChaptersPG18Continuous Archiving and Point-in-Time Recovery (PITR)You can use pg_basebackup to take an incremental backup by specifying the --incremental option. You must supply, as an argument to --incremental, the backup manifest to an earlier backup fro… maludb_coreExtensionsExtensionsAI and vectors · ExtensionsPostgreSQL memory and knowledge graph with tenant schemas, vector retrieval, and scoped principals database memory postgresql postgresql-extension maludb_core AI and vectors malwaredb_pgExtensionsExtensionsAI and vectors · ExtensionsPostgreSQL extension for MalwareDB similarity functions: SSDeep, LZJD, and TLSH malware pgrx similarity malwaredb_pg AI and vectors Managing CollationsManual ChaptersPG18Collation SupportA collation is an SQL schema object that maps an SQL name to locales provided by libraries installed in the operating system. A collation definition has a provider that specifies which libra… Managing Configuration File ContentsManual ChaptersPG18Setting ParametersPostgreSQL provides several features for breaking down complex postgresql.conf files into sub-files. These features are especially useful when managing multiple servers with related, but not… Managing Database ConnectionsManual ChaptersPG18This section describes how to open, close, and switch database connections. Managing DatabasesManual ChaptersPG18Every instance of a running PostgreSQL server manages one or more databases. Databases are therefore the topmost hierarchical level for organizing SQL objects (“database objects”). This chap… Managing Kernel ResourcesManual ChaptersPG18PostgreSQL can sometimes exhaust various operating system resource limits, especially when multiple copies of the server are running on the same system, or in very large installations. This … Managing TransactionsManual ChaptersPG18Running SQL CommandsIn the default mode, statements are committed only when EXEC SQL COMMIT is issued. The embedded SQL interface also supports autocommit of transactions (similar to psql's default behavior) vi… manipExtensionsExtensionsFunctions and aggregates · ExtensionsVarious manipulation functions manip Functions and aggregates Manipulating DocumentsManual ChaptersPG18Additional FeaturesSection 12.3.1 showed how raw textual documents can be converted into tsvector values. PostgreSQL also provides functions and operators that can be used to manipulate documents that are alre… Manipulating QueriesManual ChaptersPG18Additional FeaturesSection 12.3.2 showed how raw textual queries can be converted into tsquery values. PostgreSQL also provides functions and operators that can be used to manipulate queries that are already i… ManpagesManual ChaptersPG18Building the Documentation with MakeWe use the DocBook XSL stylesheets to convert DocBook refentry pages to *roff output suitable for man pages. To create the man pages, use the command: doc/src/sgml$ make man mansueli-function_vcExtensionsExtensionsAdministration · ExtensionsIn database version control for postgres functions database.dev tle mansueli-function_vc Administration