create database - Docs search results , p.8
Documentation >> PostgreSQL 16
53.51. pg_statistic
database. Entries are created by ANALYZE and subsequently used by the query planner. Note that
Documentation >> PostgreSQL 16
33.1. Running the Tests
database by this name will be dropped. The tests will also transiently create some cluster
Documentation >> PostgreSQL 16
26.2. File System Level Backup
database server is running. However, a backup created in this way saves the database files
Documentation >> PostgreSQL 16
PostgreSQL Server Applications
database server resides. Other utility programs are listed in PostgreSQL Client Applications . Table of Contents initdb — create
Documentation >> PostgreSQL 16
PREPARE
database session. When the session ends, the prepared statement is forgotten, so it must be recreated
Documentation >> PostgreSQL 16
43.10. Trigger Functions
database events. A trigger function is created with the CREATE FUNCTION command, declaring it as a function
Documentation >> PostgreSQL 16
27.4. Hot Standby
database using PL functions will still be possible, even though the transaction is read-only locally. The following types of administration commands are not accepted during recovery mode: Data Definition Language (DDL): e.g., CREATE
Documentation >> PostgreSQL 16
pg_ctl
creates a new PostgreSQL database cluster, that is, a collection of databases that will be managed
Documentation >> PostgreSQL 16
F.28. pgcrypto — cryptographic functions
CREATE privilege on the current database. pgcrypto requires OpenSSL and won't be installed if OpenSSL
Documentation >> PostgreSQL 16
73.1. Database File Layout
database can use the same CREATE TABLESPACE location value without conflicts.) Within the version-specific
Documentation >> PostgreSQL 16
CREATE FOREIGN DATA WRAPPER
creates a new foreign-data wrapper. The user who defines a foreign-data wrapper becomes its owner. The foreign-data wrapper name must be unique within the database
Documentation >> PostgreSQL 16
F.44. tcn — a trigger function to notify listeners of changes to table content
CREATE privilege on the current database. Only one parameter may be supplied to the function
Documentation >> PostgreSQL 16
F.9. btree_gist — GiST operator classes with B-tree behavior
CREATE privilege on the current database. F.9.1. Example Usage # Simple example using btree_gist instead
Documentation >> PostgreSQL 16
DO
database by means of CREATE EXTENSION . plpgsql is installed by default, but other languages are not. The user
Documentation >> PostgreSQL 16
5.4. Constraints
database systems.) The above example could also be written as: CREATE TABLE products ( product_no integer