PostgreSQL: The world's most advanced open source database
2024-09-26 - PostgreSQL 17 Released! The PostgreSQL Global Development Group today announced the release of PostgreSQL 17, the latest version of the world's most advanced open source database. PostgreSQL 17 builds on decades of open source development, improving its performance and scalability while adapting to emergent data access and storage patterns.
PostgreSQL: Documentation: 17: 8.1. Numeric Types
Sep 26, 2024 · The type numeric can store numbers with a very large number of digits. It is especially recommended for storing monetary amounts and other quantities where exactness is required. Calculations with numeric values yield exact results where possible, e.g., addition, subtraction, multiplication. However, calculations on numeric values are very slow compared to the integer types, or to the floating ...
PostgreSQL: Documentation: 17: Chapter 8. Data Types
Sep 26, 2024 · PostgreSQL has a rich set of native data types available to users. Users can add new types to PostgreSQL using the CREATE TYPE command.. Table 8.1 shows all the built-in general-purpose data types. Most of the alternative names listed in the “ Aliases ” column are the names used internally by PostgreSQL for historical reasons. In addition, some internally used or deprecated types are ...
PostgreSQL: Documentation: 17: psql
Sep 26, 2024 · \da[S] [ pattern] # Lists aggregate functions, together with their return type and the data types they operate on. If pattern is specified, only aggregates whose names match the pattern are shown. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects. \dA[+] [ pattern] # Lists access methods.
PostgreSQL: Documentation: 17: pg_dump
Sep 26, 2024 · -E encoding--encoding=encoding Create the dump in the specified character set encoding. By default, the dump is created in the database encoding. (Another way to get the same result is to set the PGCLIENTENCODING environment variable to the desired dump encoding.) The supported encodings are described in Section 23.3.1.-f file--file=file Send output to the specified file.
Linux downloads - PostgreSQL
Sep 26, 2024 · Linux downloads . Please select your distribution below: Debian Red Hat/Rocky SUSE Ubuntu Other Linux Generic linux distributions. PostgreSQL is available integrated with the package management on most Linux platforms.
Linux downloads (Ubuntu) - PostgreSQL
Linux downloads (Ubuntu) PostgreSQL is available in all Ubuntu versions by default. However, Ubuntu "snapshots" a specific version of PostgreSQL that is then supported throughout the lifetime of that Ubuntu version.
About - PostgreSQL
About What is PostgreSQL? PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads.
PostgreSQL: Documentation: 17: 9.18. Conditional Expressions
Sep 26, 2024 · The SQL CASE expression is a generic conditional expression, similar to if/else statements in other programming languages:. CASE WHEN condition THEN result [WHEN ...] [ELSE result] END CASE clauses can be used wherever an expression is valid. Each condition is an expression that returns a boolean result. If the condition's result is true, the value of the CASE expression is the result that ...
7.8. WITH Queries (Common Table Expressions) - PostgreSQL
Sep 26, 2024 · WITH provides a way to write auxiliary statements for use in a larger query. These statements, which are often referred to as Common Table Expressions or CTEs, can be thought of as defining temporary tables that exist just for one query.Each auxiliary statement in a WITH clause can be a SELECT, INSERT, UPDATE, DELETE, or MERGE; and the WITH clause itself is attached to a primary statement that ...