create database - Docs search results , p.8

CREATE STATISTICS

created in the current database and will be owned by the user issuing the command

33.1. Running the Tests

database by this name will be dropped. The tests will also transiently create some cluster

26.2. File System Level Backup

database server is running. However, a backup created in this way saves the database files

PostgreSQL Server Applications

database server resides. Other utility programs are listed in PostgreSQL Client Applications . Table of Contents initdb — create

PREPARE

database session. When the session ends, the prepared statement is forgotten, so it must be recreated

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

pg_ctl

creates a new PostgreSQL database cluster, that is, a collection of databases that will be managed

F.28. pgcrypto

CREATE privilege on the current database. pgcrypto requires OpenSSL and won't be installed if OpenSSL

73.1. Database File Layout

database can use the same CREATE TABLESPACE location value without conflicts.) Within the version-specific

F.44. tcn

CREATE privilege on the current database. Only one parameter may be supplied to the function

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

43.10. Trigger Functions

database events. A trigger function is created with the CREATE FUNCTION command, declaring it as a function

F.9. btree_gist

CREATE privilege on the current database. F.9.1. Example Usage Simple example using btree_gist instead

DO

database by means of CREATE EXTENSION . plpgsql is installed by default, but other languages are not. The user

5.4. Constraints

database systems.) The above example could also be written as: CREATE TABLE products ( product_no integer