create database - Docs search results , p.6

CREATE EXTENSION

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

20.1. Database Roles

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

CREATE PUBLICATION

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

Part I. Tutorial

Creating a Database 1.4. Accessing a Database 2. The SQL Language 2.1. Introduction 2.2. Concepts

ALTER ROLE

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

5.13. Dependency Tracking

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

20.3. Role Membership

database objects created are considered owned by the group role not the login role. Second

F.47. postgres_fdw

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

ALTER SCHEMA

CREATE privilege for the database. To alter the owner, you must also be a direct

F.9. citext

database is created. It is not truly case-insensitive in the terms defined by the Unicode

pg_recvlogical

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

Chapter 17. Server Setup and Operation

Creating a Database Cluster 17.2.1. Use of Secondary File Systems 17.2.2. Use of Network File

ALTER COLLATION

database was created using version 1.2.3.4, but the operating system provides version 2.3.4.5. HINT: Rebuild

27.2. The Statistics Collector

database_conflicts for details.) temp_files bigint Number of temporary files created by queries in this

42.8. PL/Perl Under the Hood

database session — either PL/PerlU, or PL/Perl for the first SQL role that calls a PL/Perl function. Any additional Perl interpreters created