PostgreSQL: Documentation: 17: CREATE TABLESPACE
CREATE TABLESPACE CREATE TABLESPACE — define a new tablespace Synopsis CREATE TABLESPACE tablespace_name [ OWNER { new_owner | CURRENT_ROLE | …| PostgreSQL Documentation
CREATE TABLESPACE CREATE TABLESPACE — define a new tablespace Synopsis CREATE TABLESPACE tablespace_name [ OWNER { new_owner | CURRENT_ROLE | …| PostgreSQL Documentation
ALTER SEQUENCE ALTER SEQUENCE — change the definition of a sequence generator Synopsis ALTER SEQUENCE [ IF EXISTS ] name …| PostgreSQL Documentation
14.2. Statistics Used by the Planner # 14.2.1. Single-Column Statistics 14.2.2. Extended Statistics 14.2.1. Single-Column Statistics # As we saw in the …| PostgreSQL Documentation
55.3. SASL Authentication # 55.3.1. SCRAM-SHA-256 Authentication SASL is a framework for authentication in connection-oriented protocols. At the moment, PostgreSQL implements …| PostgreSQL Documentation
CREATE SUBSCRIPTION CREATE SUBSCRIPTION — define a new subscription Synopsis CREATE SUBSCRIPTION subscription_name CONNECTION 'conninfo' PUBLICATION publication_name [, ...] [ …| PostgreSQL Documentation
VACUUM VACUUM — garbage-collect and optionally analyze a database Synopsis VACUUM [ ( option [, ...] ) ] [ table_and_columns …| PostgreSQL Documentation
EXPLAIN EXPLAIN — show the execution plan of a statement Synopsis EXPLAIN [ ( option [, ...] ) ] statement …| PostgreSQL Documentation
ALTER TABLE ALTER TABLE — change the definition of a table Synopsis ALTER TABLE [ IF EXISTS ] [ ONLY …| PostgreSQL Documentation
19.7. Query Planning # 19.7.1. Planner Method Configuration 19.7.2. Planner Cost Constants 19.7.3. Genetic Query Optimizer 19.7.4. Other Planner Options 19.7.1. Planner …| PostgreSQL Documentation
Chapter 24. Routine Database Maintenance Tasks Table of Contents 24.1. Routine Vacuuming 24.1.1. Vacuuming Basics 24.1.2. Recovering Disk Space 24.1.3. Updating Planner …| PostgreSQL Documentation
24.1. Routine Vacuuming # 24.1.1. Vacuuming Basics 24.1.2. Recovering Disk Space 24.1.3. Updating Planner Statistics 24.1.4. Updating the Visibility Map 24.1.5. …| PostgreSQL Documentation
Chapter 20. Client Authentication Table of Contents 20.1. The pg_hba.conf File 20.2. User Name Maps 20.3. Authentication Methods 20.4. Trust Authentication 20.5. …| PostgreSQL Documentation
pg_dump pg_dump — extract a PostgreSQL database into a script file or other archive file Synopsis pg_dump [connection-option...] [option...] [dbname] …| PostgreSQL Documentation
9.25. Row and Array Comparisons # 9.25.1. IN 9.25.2. NOT IN 9.25.3. ANY/SOME (array) 9.25.4. ALL (array) 9.25.5. Row Constructor Comparison …| PostgreSQL Documentation
25.3. Continuous Archiving and Point-in-Time Recovery (PITR) # 25.3.1. Setting Up WAL Archiving 25.3.2. Making a Base Backup 25.3.3. Making an …| PostgreSQL Documentation
29.2. Subscription # 29.2.1. Replication Slot Management 29.2.2. Examples: Set Up Logical Replication 29.2.3. Examples: Deferred Replication Slot Creation A subscription …| PostgreSQL Documentation
29.10. Security # The role used for the replication connection must have the REPLICATION attribute (or be a superuser). If the …| PostgreSQL Documentation
29.4. Row Filters # 29.4.1. Row Filter Rules 29.4.2. Expression Restrictions 29.4.3. UPDATE Transformations 29.4.4. Partitioned Tables 29.4.5. Initial Data Synchronization …| PostgreSQL Documentation
29.7. Restrictions # Logical replication currently has the following restrictions or missing functionality. These might be addressed in future releases. The …| PostgreSQL Documentation
29.12. Quick Setup # First set the configuration options in postgresql.conf: wal_level = logical The other required settings have default values …| PostgreSQL Documentation
29.1. Publication # A publication can be defined on any physical replication primary. The node where a publication is defined is …| PostgreSQL Documentation
29.9. Monitoring # Because logical replication is based on a similar architecture as physical streaming replication, the monitoring on a publication …| PostgreSQL Documentation
29.3. Logical Replication Failover # To allow subscriber nodes to continue replicating data from the publisher node even when the publisher …| PostgreSQL Documentation
29.6. Conflicts # Logical replication behaves similarly to normal DML operations in that the data will be updated even if it …| PostgreSQL Documentation
29.11. Configuration Settings # 29.11.1. Publishers 29.11.2. Subscribers Logical replication requires several configuration options to be set. Most options are relevant …| PostgreSQL Documentation
29.5. Column Lists # 29.5.1. Examples Each publication can optionally specify which columns of each table are replicated to subscribers. The …| PostgreSQL Documentation
Chapter 26. High Availability, Load Balancing, and Replication Table of Contents 26.1. Comparison of Different Solutions 26.2. Log-Shipping Standby Servers 26.2.1. Planning …| PostgreSQL Documentation
29.8. Architecture # 29.8.1. Initial Snapshot Logical replication starts by copying a snapshot of the data on the publisher database. Once …| PostgreSQL Documentation
8.11. Text Search Types # 8.11.1. tsvector 8.11.2. tsquery PostgreSQL provides two data types that are designed to support full text …| PostgreSQL Documentation
SAVEPOINT SAVEPOINT — define a new savepoint within the current transaction Synopsis SAVEPOINT savepoint_name Description SAVEPOINT establishes a new savepoint …| PostgreSQL Documentation
F.23. pageinspect — low-level inspection of database pages # F.23.1. General Functions F.23.2. Heap Functions F.23.3. B-Tree Functions F.23.4. BRIN Functions …| PostgreSQL Documentation
5.6. System Columns # Every table has several system columns that are implicitly defined by the system. Therefore, these names cannot …| PostgreSQL Documentation
Issues with german locale on CentOS 5,6,7| PostgreSQL Mailing List Archives
The following is a real critical problem that we ran into here at TripAdvisor, but have yet figured out a clear way to mitigate.| PostgreSQL Mailing List Archives
52.10. pg_ident_file_mappings # The view pg_ident_file_mappings provides a summary of the contents of the client user name mapping configuration file, pg_ident.conf. …| PostgreSQL Documentation
52.9. pg_hba_file_rules # The view pg_hba_file_rules provides a summary of the contents of the client authentication configuration file, pg_hba.conf. A row …| PostgreSQL Documentation
52.7. pg_file_settings # The view pg_file_settings provides a summary of the contents of the server's configuration file(s). A row appears in …| PostgreSQL Documentation
22.5. Predefined Roles # PostgreSQL provides a set of predefined roles that provide access to certain, commonly needed, privileged capabilities and …| PostgreSQL Documentation
MERGE MERGE — conditionally insert, update, or delete rows of a table Synopsis [ WITH with_query [, ...] ] MERGE …| PostgreSQL Documentation
Chapter 20. Client Authentication Table of Contents 20.1. The pg_hba.conf File 20.2. User Name Maps 20.3. Authentication Methods 20.4. Trust Authentication 20.5. …| PostgreSQL Documentation
GRANT GRANT — define access privileges Synopsis GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | …| PostgreSQL Documentation
CREATE POLICY CREATE POLICY — define a new row-level security policy for a table Synopsis CREATE POLICY name ON table_name …| PostgreSQL Documentation
5.8. Privileges # When an object is created, it is assigned an owner. The owner is normally the role that executed …| PostgreSQL Documentation
The world's most advanced open source database.| PostgreSQL
E.1. Release 18 # E.1.1. Overview E.1.2. Migration to Version 18 E.1.3. Changes E.1.4. Acknowledgments Release date: 2025-??-??, CURRENT AS OF 2025-06-20 …| PostgreSQL Documentation
Beta Information | www.postgresql.org
20.13. Version and Platform Compatibility # 20.13.1. Previous PostgreSQL Versions 20.13.2. Platform and Client Compatibility 20.13.1. Previous PostgreSQL Versions # array_nulls (boolean) …| PostgreSQL Documentation
Support a wildcard in backtrace_functions| PostgreSQL Mailing List Archives
19.17. Developer Options # The following parameters are intended for developer testing, and should never be used on a production database. …| PostgreSQL Documentation
psql psql — PostgreSQL interactive terminal Synopsis psql [option...] [dbname [username]] Description psql is a terminal-based front-end to PostgreSQL. It …| PostgreSQL Documentation
F.6. bloom — bloom filter index access method # F.6.1. Parameters F.6.2. Examples F.6.3. Operator Class Interface F.6.4. Limitations F.6.5. Authors …| PostgreSQL Documentation
Table of ContentsPreface| PostgreSQL Documentation
TRUNCATE TRUNCATE — empty a table or set of tables Synopsis TRUNCATE [ TABLE ] [ ONLY ] name [ …| PostgreSQL Documentation
CLUSTER CLUSTER — cluster a table according to an index Synopsis CLUSTER [ ( option [, ...] ) ] [ …| PostgreSQL Documentation
vacuumdb vacuumdb — garbage-collect and analyze a PostgreSQL database Synopsis vacuumdb [connection-option...] [option...] [ -t | --table table [( column …| PostgreSQL Documentation
dblink dblink — executes a query in a remote database Synopsis dblink(text connname, text sql [, bool fail_on_error]) returns setof …| PostgreSQL Documentation
26.2. Log-Shipping Standby Servers # 26.2.1. Planning 26.2.2. Standby Server Operation 26.2.3. Preparing the Primary for Standby Servers 26.2.4. Setting Up …| PostgreSQL Documentation
53.21. pg_replication_slots # The pg_replication_slots view provides a listing of all replication slots that currently exist on the database cluster, along …| PostgreSQL Documentation
54.4. Streaming Replication Protocol # To initiate streaming replication, the frontend sends the replication parameter in the startup message. A Boolean …| PostgreSQL Documentation
28.1. Reliability # Reliability is an important property of any serious database system, and PostgreSQL does everything possible to guarantee reliable …| PostgreSQL Documentation
pg_checksums pg_checksums — enable, disable or check data checksums in a PostgreSQL database cluster Synopsis pg_checksums [option...] [[ -D | …| PostgreSQL Documentation
pg_verifybackup pg_verifybackup — verify the integrity of a base backup of a PostgreSQL cluster Synopsis pg_verifybackup [option...] Description pg_verifybackup is …| PostgreSQL Documentation
Chapter 28. Reliability and the Write-Ahead Log Table of Contents 28.1. Reliability 28.2. Data Checksums 28.2.1. Off-line Enabling of Checksums 28.3. Write-Ahead …| PostgreSQL Documentation
65.6. Database Page Layout # 65.6.1. Table Row Layout This section provides an overview of the page format used within PostgreSQL …| PostgreSQL Documentation
63.1. Generic WAL Records # Although all built-in WAL-logged modules have their own types of WAL records, there is also a …| PostgreSQL Documentation
63.2. Custom WAL Resource Managers # This section explains the interface between the core PostgreSQL system and custom WAL resource managers, …| PostgreSQL Documentation
36.13. User-Defined Types # 36.13.1. TOAST Considerations As described in Section 36.2, PostgreSQL can be extended to support new data types. This …| PostgreSQL Documentation
CREATE SERVER CREATE SERVER — define a new foreign server Synopsis CREATE SERVER [ IF NOT EXISTS ] server_name [ …| PostgreSQL Documentation
Chapter 8. Data Types Table of Contents 8.1. Numeric Types 8.1.1. Integer Types 8.1.2. Arbitrary Precision Numbers 8.1.3. Floating-Point Types 8.1.4. Serial …| PostgreSQL Documentation
2.7. Aggregate Functions # Like most other relational database products, PostgreSQL supports aggregate functions. An aggregate function computes a single result …| PostgreSQL Documentation
9.15. XML Functions # 9.15.1. Producing XML Content 9.15.2. XML Predicates 9.15.3. Processing XML 9.15.4. Mapping Tables to XML The functions …| PostgreSQL Documentation
9.22. Window Functions # Window functions provide the ability to perform calculations across sets of rows that are related to the …| PostgreSQL Documentation
21.3. Role Membership # It is frequently convenient to group users together to ease management of privileges: that way, privileges can …| PostgreSQL Documentation
21.5. Predefined Roles # PostgreSQL provides a set of predefined roles that provide access to certain, commonly needed, privileged capabilities and …| PostgreSQL Documentation
21.1. Database Roles # Database roles are conceptually completely separate from operating system users. In practice it might be convenient to …| PostgreSQL Documentation
CREATE TYPE CREATE TYPE — define a new data type Synopsis CREATE TYPE name AS ( [ attribute_name data_type [ …| PostgreSQL Documentation
8.16. Composite Types # 8.16.1. Declaration of Composite Types 8.16.2. Constructing Composite Values 8.16.3. Accessing Composite Types 8.16.4. Modifying Composite Types …| PostgreSQL Documentation
9.20. Range/Multirange Functions and Operators # See Section 8.17 for an overview of range types. Table 9.56 shows the specialized operators available for …| PostgreSQL Documentation
F.8. btree_gist — GiST operator classes with B-tree behavior # F.8.1. Example Usage F.8.2. Authors btree_gist provides GiST index operator classes …| PostgreSQL Documentation
62.5. Index Uniqueness Checks # PostgreSQL enforces SQL uniqueness constraints using unique indexes, which are indexes that disallow multiple entries with …| PostgreSQL Documentation
9.26. System Information Functions and Operators Table 9.65 shows several functions that extract session and system information. In addition to the functions …| PostgreSQL Documentation
5.9. Schemas 5.9.1. Creating a Schema 5.9.2. The Public Schema 5.9.3. The Schema Search Path 5.9.4. Schemas and Privileges 5.9.5. The …| PostgreSQL Documentation
PostgreSQL 14.18 Documentation The PostgreSQL Global Development Group Copyright © 1996–2025 The PostgreSQL Global Development Group Legal Notice Table of …| PostgreSQL Documentation
Documentation | www.postgresql.org
9.27. System Information Functions and Operators # 9.27.1. Session Information Functions 9.27.2. Access Privilege Inquiry Functions 9.27.3. Schema Visibility Inquiry Functions …| PostgreSQL Documentation
5.10. Schemas # 5.10.1. Creating a Schema 5.10.2. The Public Schema 5.10.3. The Schema Search Path 5.10.4. Schemas and Privileges 5.10.5. …| PostgreSQL Documentation
3.4. Transactions # Transactions are a fundamental concept of all database systems. The essential point of a transaction is that it …| PostgreSQL Documentation
22.3. Template Databases # CREATE DATABASE actually works by copying an existing database. By default, it copies the standard system database …| PostgreSQL Documentation
Hi, On Wed, Mar 26, 2025 at 4:59 PM Ashutosh Bapat wrote: > > > The averages are now …| PostgreSQL Mailing List Archives
36.17. Packaging Related Objects into an Extension # 36.17.1. Extension Files 36.17.2. Extension Relocatability 36.17.3. Extension Configuration Tables 36.17.4. Extension Updates …| PostgreSQL Documentation
Appendix F. Additional Supplied Modules and Extensions Table of Contents F.1. adminpack — pgAdmin support toolpack F.2. amcheck — tools to verify …| PostgreSQL Documentation
E.6. Release 17 # E.6.1. Overview E.6.2. Migration to Version 17 E.6.3. Changes E.6.4. Acknowledgments Release date: 2024-09-26 E.6.1. Overview # PostgreSQL 17 …| PostgreSQL Documentation
9.16. JSON Functions and Operators # 9.16.1. Processing and Creating JSON Data 9.16.2. The SQL/JSON Path Language 9.16.3. SQL/JSON Query Functions …| PostgreSQL Documentation
64.4. GIN Indexes # 64.4.1. Introduction 64.4.2. Built-in Operator Classes 64.4.3. Extensibility 64.4.4. Implementation 64.4.5. GIN Tips and Tricks 64.4.6. Limitations …| PostgreSQL Documentation
64.1. B-Tree Indexes # 64.1.1. Introduction 64.1.2. Behavior of B-Tree Operator Classes 64.1.3. B-Tree Support Functions 64.1.4. Implementation 64.1.1. Introduction # PostgreSQL …| PostgreSQL Documentation
2.7. Aggregate Functions| PostgreSQL Documentation
4.2.7. Aggregate Expressions| PostgreSQL Documentation
