create database - Docs search results , p.5

41.1. Overview

database users can be trusted to use this language; it does not give them unlimited authority. The other notable implementation restriction is that Tcl functions cannot be used to create

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

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.13. Dependency Tracking This chapter covers how one creates the database structures that

20.1. Database Roles

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

ALTER ROLE

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

E.26. Release 9.5

CREATE / ALTER DATABASE to manipulate datistemplate and datallowconn (Vik Fearing) This allows these per-database

5.13. Dependency Tracking

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

E.18. Release 9.5.8

database of the cluster, run the following commands as superuser: SET search_path = pg_catalog; CREATE

Part I. Tutorial

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

20.3. Role Membership

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

F.31. 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.7. 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