create database - Docs search results , p.4

pgbench

database sessions. The default TPC-B-like transaction test requires specific tables to be set up beforehand. pgbench should be invoked with the -i (initialize) option to create

Part III. Server Administration

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

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

19.5. Write Ahead Log

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

DROP DATABASE

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

52.8. pg_authid

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

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

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

53.2. Message Flow

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

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