create database - Docs search results , p.5

PostgreSQL Client Applications

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

38.17. Packaging Related Objects into an Extension

CREATE privilege on the current database. When the user executing CREATE EXTENSION is not a superuser

ALTER ROLE

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

Chapter 23. Managing Databases

Databases Table of Contents 23.1. Overview 23.2. Creating a Database 23.3. Template Databases 23.4. Database

F.10. citext — a case-insensitive character string type

CREATE privilege on the current database. F.10.1. Rationale # The standard approach to doing case-insensitive

44.1. Overview

database, use the CREATE EXTENSION command, for example CREATE EXTENSION pltcl or CREATE EXTENSION pltclu

CREATE EXTENSION

CREATE EXTENSION loads a new extension into the current database. There must not be an extension

Chapter 5. Data Definition

Database Objects 5.14. Dependency Tracking This chapter covers how one creates the database structures that

pg_recvlogical

created. The connection must be to the same database used to create the slot. --create

CREATE PUBLICATION

CREATE PUBLICATION adds a new publication into the current database. The publication name must be distinct

28.5. Dynamic Tracing

database, and relation OIDs identifying the relation. arg4 is the ID of the backend which created

22.5. Predefined Roles

CREATE permission on the database to issue CREATE SUBSCRIPTION . The pg_monitor , pg_read_all_settings

22.1. Database Roles

database). To create a role use the CREATE ROLE SQL command: CREATE ROLE name ; name

F.38. postgres_fdw — access data stored in external PostgreSQL servers

CREATE SERVER , to represent each remote database you want to connect to. Specify connection information

5.14. Dependency Tracking

create complex database structures involving many tables with foreign key constraints, views, triggers, functions, etc. you implicitly