create database - Docs search results , p.8

Chapter 46. Background Worker Processes

create and use. BGWORKER_BACKEND_DATABASE_CONNECTION Requests the ability to establish a database connection

3.6. Inheritance

database design. Let's create two tables: A table cities and a table capitals . Naturally

14.4. Populating a Database

recreate the indexes. Of course, the database performance for other users might suffer during the time

8.1. Numeric Types

creating unique identifier columns (similar to the AUTO_INCREMENT property supported by some other databases

50.55. pg_type

created for each table in the database, to represent the row structure of the table

14.5. Non-Durable Settings

database software; only abrupt operating system stoppage creates a risk of data loss or corruption

36.4. Query Language (SQL) Functions

creates a need for precautions when calling functions in databases where some users mistrust other

pg_standby

creation of a “ warm standby ” database server. It is designed to be a production-ready

26.2. Log-Shipping Standby Servers

create the primary and standby servers so that they are as similar as possible, at least from the perspective of the database

psql

database roles. (Since the concepts of “ users ” and “ groups ” have been unified into “ roles ” , this command is now equivalent to \du .) By default, only user-created

32.6. Canceling Queries in Progress

Creates a data structure containing the information needed to cancel a command issued through a particular database

5.4. System Columns

database-wide identifier. Of course, the tables in question must be created WITH OIDS . As of PostgreSQL

CREATE FOREIGN TABLE

creates a new foreign table in the current database. The table will be owned by the user

19.3. Connections and Authentication

database user names. It is off by default. This parameter can only be set in the postgresql.conf file or on the server command line. If this is on, you should create

ALTER INDEX

CREATE privilege on the new tablespace. All indexes in the current database in a tablespace