create database - Docs search results , p.5

52.37. pg_pltemplate

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

Chapter 22. Managing Databases

Databases Table of Contents 22.1. Overview 22.2. Creating a Database 22.3. Template Databases 22.4. Database

44.1. Overview

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

38.16. Packaging Related Objects into an Extension

database management. PostgreSQL calls such a package an extension . To define an extension, you need at least a script file that contains the SQL commands to create

Chapter 5. Data Definition

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

CREATE EXTENSION

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

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

E.22. Release 11.1

database freshly created in 11.0 should not need this, but a database upgraded from a previous

5.13. Dependency Tracking

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

Part I. Tutorial

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

21.3. Role Membership

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

F.33. 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.8. citext

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