create database - Docs search results , p.8

CREATE TABLE

create a new, initially empty table in the current database. The table will be owned

pg_upgrade

database schemas, and not user data. For deployment testing, create a schema-only copy of the old cluster

CREATE SUBSCRIPTION

CREATE SUBSCRIPTION adds a new subscription for the current database. The subscription name must be distinct

42.5. Trusted and Untrusted PL/Perl

database superusers to create functions in untrusted languages. If the above function was created by a superuser

30.7. Security

CREATE privilege in the database. To add tables to a publication, the user must have

17.6. Upgrading a Postgres Pro Cluster

Create a new database cluster if needed. Remember that you must execute these commands while

50.4. Streaming Replication Protocol

created in a database other than the database the walsender is connected to, this command

49.50. pg_statistic

database. Entries are created by ANALYZE and subsequently used by the query planner. Note that

24.2. File System Level Backup

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

PREPARE

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

CREATE STATISTICS

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

25.5. 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

63.1. Database File Layout

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

5.3. Constraints

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

F.43. pg_tsparser

create the pg_tsparser extension for each database you are planning to use: CREATE EXTENSION