create database - Docs search results , p.4

49.1. Overview

database creation and are thereafter database-specific. A few catalogs are physically shared across all databases

18.5. Write Ahead Log

database will be thrown away and recreated, or for a read-only database clone which

pg_basebackup

database.) To create a backup of a local database where the tablespace in /opt/ts is relocated

DROP DATABASE

DATABASE statement in the SQL standard. See Also CREATE DATABASE Prev   Up   Next DROP CONVERSION

PostgreSQL Client Applications

database createdb — create a new PostgreSQL database createlang — install a PostgreSQL procedural language createuser — define

49.79. pg_user

create databases usesuper bool User is a superuser userepl bool User can initiate streaming replication

1.4. Accessing a Database

Database Once you have created a database, you can access it by: Running the PostgreSQL

49.8. pg_authid

create databases rolcanlogin bool Role can log in. That is, this role can be given

CREATE SERVER

database. Creating a server requires USAGE privilege on the foreign-data wrapper being used. Parameters

E.21. Release 9.5.5

CREATE DATABASE if --no-tablespaces is specified (Tom Lane) Make pg_receivexlog work correctly with

49.70. pg_roles

create databases rolcanlogin bool   Role can log in. That is, this role can be given

Chapter 64. BKI Backend Interface

creating a new database cluster. The input file used by initdb is created as part

49.74. pg_shadow

create databases usesuper bool   User is a superuser userepl bool   User can initiate streaming replication

49.35. pg_pltemplate

created in a particular database by a simple CREATE LANGUAGE command, with no need to specify

Chapter 21. Managing Databases

Databases Table of Contents 21.1. Overview 21.2. Creating a Database 21.3. Template Databases 21.4. Database