create database - Docs search results , p.5
Documentation >> PostgreSQL 9.6
36.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
Documentation >> PostgreSQL 9.6
Chapter 5. Data Definition
Database Objects 5.13. Dependency Tracking This chapter covers how one creates the database structures that
Documentation >> PostgreSQL 9.6
CREATE EXTENSION
CREATE EXTENSION loads a new extension into the current database. There must not be an extension
Documentation >> PostgreSQL 9.6
21.1. Database Roles
database). To create a role use the CREATE ROLE SQL command: CREATE ROLE name ; name
Documentation >> PostgreSQL 9.6
ALTER ROLE
CREATE ROLE reference page. new_name The new name of the role. database_name The name
Documentation >> PostgreSQL 9.6
E.21. Release 9.6.4
database of the cluster, run the following commands as superuser: SET search_path = pg_catalog; CREATE
Documentation >> PostgreSQL 9.6
5.13. Dependency Tracking
create complex database structures involving many tables with foreign key constraints, views, triggers, functions, etc. you implicitly
Documentation >> PostgreSQL 9.6
Part I. Tutorial
Creating a Database 1.4. Accessing a Database 2. The SQL Language 2.1. Introduction 2.2. Concepts
Documentation >> PostgreSQL 9.6
21.3. Role Membership
database objects created are considered owned by the group role not the login role. Second
Documentation >> PostgreSQL 9.6
F.33. postgres_fdw
CREATE SERVER , to represent each remote database you want to connect to. Specify connection information
Documentation >> PostgreSQL 9.6
ALTER SCHEMA
CREATE privilege for the database. To alter the owner, you must also be a direct
Documentation >> PostgreSQL 9.6
F.8. citext
database is created. It is not truly case-insensitive in the terms defined by the Unicode
Documentation >> PostgreSQL 9.6
pg_recvlogical
created. The connection must be to the same database used to create the slot. --create
Documentation >> PostgreSQL 9.6
Chapter 18. Server Setup and Operation
Creating a Database Cluster 18.2.1. Use of Secondary File Systems 18.2.2. Use of Network File
Documentation >> PostgreSQL 9.6
43.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