create database - Docs search results , p.4

Part III. Server Administration

Creating a Database Cluster 18.3. Starting the Database Server 18.4. Managing Kernel Resources 18.5. Shutting

19.5. Write Ahead Log

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

51.1. Overview

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

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

51.8. pg_authid

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

51.82. pg_roles

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

PostgreSQL Client Applications

database createdb — create a new PostgreSQL database createuser — define a new PostgreSQL user account dropdb

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

CREATE SERVER

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

52.2. Message Flow

CREATE DATABASE ) that cannot be executed inside a transaction block. If one of these is executed

51.87. pg_shadow

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

ALTER ROLE

CREATE ROLE reference page. new_name The new name of the role. database_name The name

51.37. pg_pltemplate

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