create database - Docs search results , p.5
Documentation >> PostgreSQL 16
PostgreSQL Client Applications
database createdb — create a new PostgreSQL database createuser — define a new PostgreSQL user account dropdb
Documentation >> PostgreSQL 16
38.17. Packaging Related Objects into an Extension
CREATE privilege on the current database. When the user executing CREATE EXTENSION is not a superuser
Documentation >> PostgreSQL 16
ALTER ROLE
CREATE ROLE reference page. new_name # The new name of the role. database_name # The name
Documentation >> PostgreSQL 16
Chapter 23. Managing Databases
Databases Table of Contents 23.1. Overview 23.2. Creating a Database 23.3. Template Databases 23.4. Database
Documentation >> PostgreSQL 16
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
Documentation >> PostgreSQL 16
44.1. Overview
database, use the CREATE EXTENSION command, for example CREATE EXTENSION pltcl or CREATE EXTENSION pltclu
Documentation >> PostgreSQL 16
CREATE EXTENSION
CREATE EXTENSION loads a new extension into the current database. There must not be an extension
Documentation >> PostgreSQL 16
Chapter 5. Data Definition
Database Objects 5.14. Dependency Tracking This chapter covers how one creates the database structures that
Documentation >> PostgreSQL 16
pg_recvlogical
created. The connection must be to the same database used to create the slot. --create
Documentation >> PostgreSQL 16
CREATE PUBLICATION
CREATE PUBLICATION adds a new publication into the current database. The publication name must be distinct
Documentation >> PostgreSQL 16
28.5. Dynamic Tracing
database, and relation OIDs identifying the relation. arg4 is the ID of the backend which created
Documentation >> PostgreSQL 16
22.5. Predefined Roles
CREATE permission on the database to issue CREATE SUBSCRIPTION . The pg_monitor , pg_read_all_settings
Documentation >> PostgreSQL 16
22.1. Database Roles
database). To create a role use the CREATE ROLE SQL command: CREATE ROLE name ; name
Documentation >> PostgreSQL 16
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
Documentation >> PostgreSQL 16
5.14. Dependency Tracking
create complex database structures involving many tables with foreign key constraints, views, triggers, functions, etc. you implicitly