create database - Docs search results , p.10
Documentation >> Postgres Pro Standard 9.6
48.46. pg_statistic
database. Entries are created by ANALYZE and subsequently used by the query planner. Note that
Documentation >> Postgres Pro Standard 9.6
24.2. File System Level Backup
database server is running. However, a backup created in this way saves the database files
Documentation >> Postgres Pro Standard 9.6
PREPARE
database session. When the session ends, the prepared statement is forgotten, so it must be recreated
Documentation >> Postgres Pro Standard 9.6
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
Documentation >> Postgres Pro Standard 9.6
61.1. Database File Layout
database can use the same CREATE TABLESPACE location value without conflicts.) Within the version-specific
Documentation >> Postgres Pro Standard 9.6
5.3. Constraints
database systems.) The above example could also be written as: CREATE TABLE products ( product_no integer
Documentation >> Postgres Pro Standard 9.6
F.43. pg_tsparser
create the pg_tsparser extension for each database you are planning to use: CREATE EXTENSION
Documentation >> Postgres Pro Standard 9.6
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 >> Postgres Pro Standard 9.6
39.9. Trigger Procedures
database events. A trigger procedure is created with the CREATE FUNCTION command, declaring it as a function
Documentation >> Postgres Pro Standard 9.6
DO
database by means of CREATE LANGUAGE . plpgsql is installed by default, but other languages are not. The user
Documentation >> Postgres Pro Standard 9.6
30.21. Example Programs
database with the following commands * (provided in src/test/examples/testlibpq2.sql): * * CREATE SCHEMA TESTLIBPQ2; * SET search_path = TESTLIBPQ2
Documentation >> Postgres Pro Standard 9.6
III. Postgres Pro Server Applications
database server resides. Other utility programs are listed in Postgres Pro Client Applications . Table of Contents initdb — create
Documentation >> Postgres Pro Standard 9.6
Chapter 44. Background Worker Processes
create and use. BGWORKER_BACKEND_DATABASE_CONNECTION Requests the ability to establish a database connection
Documentation >> Postgres Pro Standard 9.6
pg_ctl
creates a new Postgres Pro database cluster. A database cluster is a collection of databases
Documentation >> Postgres Pro Standard 9.6
3.6. Inheritance
database design. Let's create two tables: A table cities and a table capitals . Naturally