PostgreSQL: Documentation: 9.1: PREPARE
PostgreSQL 9.1.24 Documentation| PostgreSQL Documentation
shared_buffers (integer)| PostgreSQL Documentation
Table of ContentsPreface| PostgreSQL Documentation
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
48.39. pg_replication_slots| PostgreSQL Documentation
pg_ctl pg_ctl — initialize, start, stop, or control a PostgreSQL server Synopsis pg_ctl init[db] [-D datadir] [-s] [-o initdb-options] pg_ctl …| PostgreSQL Documentation
TRUNCATE TRUNCATE — empty a table or set of tables Synopsis TRUNCATE [ TABLE ] [ ONLY ] name [ …| 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
pg_test_fsync pg_test_fsync — determine fastest wal_sync_method for PostgreSQL Synopsis pg_test_fsync [option...] Description pg_test_fsync is intended to give you a reasonable …| PostgreSQL Documentation
initdb initdb — create a new PostgreSQL database cluster Synopsis initdb [option...] [ --pgdata | -D ] directory Description initdb …| 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
21.2. Role Attributes # A database role can have a number of attributes that define its privileges and interact with the …| PostgreSQL Documentation
20.1. The pg_hba.conf File # Client authentication is controlled by a configuration file, which traditionally is named pg_hba.conf and is stored …| PostgreSQL Documentation
pg_combinebackup pg_combinebackup — reconstruct a full backup from an incremental backup and dependent backups Synopsis pg_combinebackup [option...] [backup_directory...] Description pg_combinebackup …| PostgreSQL Documentation
DROP SERVER DROP SERVER — remove a foreign server descriptor Synopsis DROP SERVER [ IF EXISTS ] name [, ...] …| PostgreSQL Documentation
CREATE USER MAPPING CREATE USER MAPPING — define a new mapping of a user to a foreign server Synopsis CREATE …| PostgreSQL Documentation
CREATE FOREIGN DATA WRAPPER CREATE FOREIGN DATA WRAPPER — define a new foreign-data wrapper Synopsis CREATE FOREIGN DATA WRAPPER name …| PostgreSQL Documentation
ALTER SERVER ALTER SERVER — change the definition of a foreign server Synopsis ALTER SERVER name [ VERSION 'new_version' ] …| PostgreSQL Documentation
F.36. postgres_fdw — access data stored in external PostgreSQL servers # F.36.1. FDW Options of postgres_fdw F.36.2. Functions F.36.3. Connection Management …| PostgreSQL Documentation
F.11. dblink — connect to other PostgreSQL databases # dblink_connect — opens a persistent connection to a remote database dblink_connect_u — …| PostgreSQL Documentation
dblink_connect dblink_connect — opens a persistent connection to a remote database Synopsis dblink_connect(text connstr) returns text dblink_connect(text connname, text connstr) …| PostgreSQL Documentation
Chapter 12. Full Text Search Table of Contents 12.1. Introduction 12.1.1. What Is a Document? 12.1.2. Basic Text Matching 12.1.3. Configurations 12.2. …| PostgreSQL Documentation
12.2. Tables and Indexes # 12.2.1. Searching a Table 12.2.2. Creating Indexes The examples in the previous section illustrated full text …| PostgreSQL Documentation
12.4. Additional Features # 12.4.1. Manipulating Documents 12.4.2. Manipulating Queries 12.4.3. Triggers for Automatic Updates 12.4.4. Gathering Document Statistics This section …| PostgreSQL Documentation
12.3. Controlling Text Search # 12.3.1. Parsing Documents 12.3.2. Parsing Queries 12.3.3. Ranking Search Results 12.3.4. Highlighting Results To implement full …| PostgreSQL Documentation
F.35. pg_trgm — support for similarity of text using trigram matching # F.35.1. Trigram (or Trigraph) Concepts F.35.2. Functions and Operators …| PostgreSQL Documentation
F.38. postgres_fdw — access data stored in external PostgreSQL servers # F.38.1. FDW Options of postgres_fdw F.38.2. Functions F.38.3. Connection Management …| PostgreSQL Documentation
Chapter 10. Type Conversion Table of Contents 10.1. Overview 10.2. Operators 10.3. Functions 10.4. Value Storage 10.5. UNION, CASE, and Related Constructs …| PostgreSQL Documentation
ALTER INDEX ALTER INDEX — change the definition of an index Synopsis ALTER INDEX [ IF EXISTS ] name RENAME …| PostgreSQL Documentation
18.6. Upgrading a PostgreSQL Cluster # 18.6.1. Upgrading Data via pg_dumpall 18.6.2. Upgrading Data via pg_upgrade 18.6.3. Upgrading Data via Replication …| PostgreSQL Documentation
13.3. Explicit Locking # 13.3.1. Table-Level Locks 13.3.2. Row-Level Locks 13.3.3. Page-Level Locks 13.3.4. Deadlocks 13.3.5. Advisory Locks PostgreSQL provides various …| PostgreSQL Documentation
54.2. Message Flow # 54.2.1. Start-up 54.2.2. Simple Query 54.2.3. Extended Query 54.2.4. Pipelining 54.2.5. Function Call 54.2.6. COPY Operations 54.2.7. …| 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
18.12. Registering Event Log on Windows # To register a Windows event log library with the operating system, issue this command: …| PostgreSQL Documentation
COMMENT COMMENT — define or change the comment of an object Synopsis COMMENT ON { ACCESS METHOD object_name | AGGREGATE …| PostgreSQL Documentation
Chapter 37. Triggers Table of Contents 37.1. Overview of Trigger Behavior 37.2. Visibility of Data Changes 37.3. Writing Trigger Functions in C …| PostgreSQL Documentation
11.3. Multicolumn Indexes # An index can be defined on more than one column of a table. For example, if you …| PostgreSQL Documentation
Bibliography Selected references and readings for SQL and PostgreSQL. Some white papers and technical reports from the original POSTGRES development …| PostgreSQL Documentation
36.16. Interfacing Extensions to Indexes # 36.16.1. Index Methods and Operator Classes 36.16.2. Index Method Strategies 36.16.3. Index Method Support Routines …| PostgreSQL Documentation
Appendix M. Glossary This is a list of terms and their meaning in the context of PostgreSQL and relational database systems in …| PostgreSQL Documentation
NOTIFY NOTIFY — generate a notification Synopsis NOTIFY channel [ , payload ] Description The NOTIFY command sends a notification …| PostgreSQL Documentation
The [PostgreSQL Global Development Group](https://www.postgresql.org) today announced the release of [PostgreSQL 18](https://www.postgresql.org/docs/18/release-18.html), the latest version of the world's most advanced …| PostgreSQL News
PREPARE PREPARE — prepare a statement for execution Synopsis PREPARE name [ ( data_type [, ...] ) ] AS statement …| PostgreSQL Documentation
COPY COPY — copy data between a file and a table Synopsis COPY table_name [ ( column_name [, ...] ) …| PostgreSQL Documentation
19.5. Write Ahead Log # 19.5.1. Settings 19.5.2. Checkpoints 19.5.3. Archiving 19.5.4. Recovery 19.5.5. Archive Recovery 19.5.6. Recovery Target 19.5.7. WAL …| PostgreSQL Documentation
19.6. Replication # 19.6.1. Sending Servers 19.6.2. Primary Server 19.6.3. Standby Servers 19.6.4. Subscribers These settings control the behavior of the …| PostgreSQL Documentation
11.9. Index-Only Scans and Covering Indexes # All indexes in PostgreSQL are secondary indexes, meaning that each index is stored separately …| PostgreSQL Documentation
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
9.26. System Information Functions and Operators # 9.26.1. Session Information Functions 9.26.2. Access Privilege Inquiry Functions 9.26.3. Schema Visibility Inquiry 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. …| 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
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
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.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.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
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
