Search PostgreSQL documentation

macaddrManual ChaptersPG188.9.4. macaddr The 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 …macaddr macaddrData TypesPG18macaddr MAC (Media Access Control) addressData Types macaddr8Manual ChaptersPG188.9.5. macaddr8 The 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).…macaddr8 macaddr8Data TypesPG18macaddr8 MAC (Media Access Control) address (EUI-64 format)Data Types macaddr8_set7bitFunctionsReferencemacaddr8_set7bit Network Address Functions And Operators 10 set 7th bit to one, also known as modified EUI-64, for inclusion in an IPv6 address macaddr8_set7bit ( macaddr8 ) → macaddr8 set 7…Functions · Network Address Functions And Operators macavityExtensionsExtensionsDeterministic session-local fault injection for PostgreSQL test clusters test fault-injection macavity AdministrationAdministration · Extensions macOSManual ChaptersPG18J.2.4. macOS If 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-xs…macOS macOSManual ChaptersPG1817.7.2. macOS To 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 wil…macOS madlibExtensionsExtensionsAn open-source in-database analytics library analytics machine learning madlib AI and vectorsAI and vectors · Extensions mageExtensionsExtensionsYugabyteDB - the cloud native distributed SQL database for mission-critical applications. cloud-native cpp database distributed-database distributed-sql distributed-sql-database high-perform…Features · Extensions Main FunctionsManual ChaptersPG1832.3.1. Main Functions PQexec # 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 p…Main Functions Maintenance for Inheritance PartitioningManual ChaptersPG185.12.3.2. Maintenance for Inheritance Partitioning To remove old data quickly, simply drop the child table that is no longer necessary: DROP TABLE measurement_y2006m02; To remove the child t…Maintenance for Inheritance Partitioning maintenance_io_concurrencyConfigurationReferencemaintenance_io_concurrency Resource Usage 13 Similar to effective_io_concurrency, but used for maintenance work that is done on behalf of many client sessions. The default is 10 on supported…Configuration · Resource Usage maintenance_work_memConfigurationReferencemaintenance_work_mem Resource Usage 10 Specifies the maximum amount of memory to be used by maintenance operations, such as VACUUM, CREATE INDEX, and ALTER TABLE ADD FOREIGN KEY. It defaults…Configuration · Resource Usage Major VersionsManual ChaptersPG1836.10.6.2.1. Major Versions There is no promise of API compatibility between PostgreSQL major versions. Extension code therefore might require source code changes to work with multiple major…Major Versions Major VersionsManual ChaptersPG1836.10.6.3.1. Major Versions Servers of different major versions have intentionally incompatible ABIs. Extensions that use server APIs must therefore be re-compiled for each major release. Th…Major Versions make_dateFunctionsReferencemake_date Date/Time Functions And Operators 10 Create date from year, month and day fields make_date ( year int, month int, day int ) → date Create date from year, month and day fields 11 12…Functions · Date/Time Functions And Operators make_intervalFunctionsReferencemake_interval Date/Time Functions And Operators 10 Create interval from years, months, weeks, days, hours, minutes and seconds fields make_interval ( years int DEFAULT 0, months int DEFAULT …Functions · Date/Time Functions And Operators make_timeFunctionsReferencemake_time Date/Time Functions And Operators 10 Create time from hour, minute and seconds fields make_time ( hour int, min int, sec double precision ) → time Create time from hour, minute and…Functions · Date/Time Functions And Operators make_timestampFunctionsReferencemake_timestamp Date/Time Functions And Operators 10 Create timestamp from year, month, day, hour, minute and seconds fields make_timestamp ( year int, month int, day int, hour int, min int, …Functions · Date/Time Functions And Operators make_timestamptzFunctionsReferencemake_timestamptz Date/Time Functions And Operators 10 Create timestamp with time zone from year, month, day, hour, minute and seconds fields; if timezone is not specified, the current time z…Functions · Date/Time Functions And Operators make_validFunctionsPG18make_valid ( isn ) → isn Clears the invalid-check-digit flag of the value.isn — data types for international standard numbers (ISBN, EAN, UPC, etc.) › Functions and Operators makeaclitemFunctionsReferencemakeaclitem System Information Functions And Operators 12 build an aclitem from input makeaclitem ( grantee, grantor, privilege, grantable ) → aclitem build an aclitem from input 13 Construc…Functions · System Information Functions And Operators Making a Base BackupManual ChaptersPG1825.3.2. Making a Base Backup 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 flexi…Making a Base Backup Making a Base Backup Using the Low Level APIManual ChaptersPG1825.3.4. Making a Base Backup Using the Low Level API Instead of taking a full or incremental base backup using pg_basebackup, you can take a base backup using the low-level API. This procedu…Making a Base Backup Using the Low Level API Making an Incremental BackupManual ChaptersPG1825.3.3. Making an Incremental Backup You can use pg_basebackup to take an incremental backup by specifying the --incremental option. You must supply, as an argument to --incremental, the bac…Making an Incremental Backup maludb_coreExtensionsExtensionsPostgreSQL memory and knowledge graph with tenant schemas, vector retrieval, and scoped principals database memory postgresql postgresql-extension maludb_core AI and vectorsAI and vectors · Extensions malwaredb_pgExtensionsExtensionsPostgreSQL extension for MalwareDB similarity functions: SSDeep, LZJD, and TLSH malware pgrx similarity malwaredb_pg AI and vectorsAI and vectors · Extensions Managing CollationsManual ChaptersPG1823.2.2. Managing Collations A 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 provide…Managing Collations Managing Configuration File ContentsManual ChaptersPG1819.1.5. Managing Configuration File Contents PostgreSQL provides several features for breaking down complex postgresql.conf files into sub-files. These features are especially useful when ma…Managing Configuration File Contents Managing Database ConnectionsManual ChaptersPG1834.2. Managing Database Connections This section describes how to open, close, and switch database connections.Managing Database Connections Managing DatabasesManual ChaptersPG18Chapter 22. Managing Databases Every instance of a running PostgreSQL server manages one or more databases. Databases are therefore the topmost hierarchical level for organizing SQL objects …Managing Databases Managing Kernel ResourcesManual ChaptersPG1818.4. Managing Kernel Resources PostgreSQL can sometimes exhaust various operating system resource limits, especially when multiple copies of the server are running on the same system, or in…Managing Kernel Resources Managing TransactionsManual ChaptersPG1834.3.3. Managing Transactions In the default mode, statements are committed only when EXEC SQL COMMIT is issued. The embedded SQL interface also supports autocommit of transactions (similar …Managing Transactions manipExtensionsExtensionsVarious manipulation functions manip Functions and aggregatesFunctions and aggregates · Extensions Manipulating DocumentsManual ChaptersPG1812.4.1. Manipulating Documents Section 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 man…Manipulating Documents Manipulating QueriesManual ChaptersPG1812.4.2. Manipulating Queries Section 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 manipula…Manipulating Queries ManpagesManual ChaptersPG18J.3.2. Manpages We 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 manManpages mansueli-function_vcExtensionsExtensionsIn database version control for postgres functions database.dev tle mansueli-function_vc AdministrationAdministration · Extensions mapcodeExtensionsExtensionsMapcodes in PostgreSQL geospatial latitude location longitude mapcode mapcode-postgres GeospatialGeospatial · Extensions