create database - Docs search results , p.6

CREATE USER

CREATE USER — define a new database role Synopsis CREATE USER name [ [ WITH ] option [ ... ] ] where option

CREATE GROUP

CREATE GROUP — define a new database role Synopsis CREATE GROUP name [ [ WITH ] option [ ... ] ] where option

F.29. pg_stat_statements

database with CREATE EXTENSION pg_stat_statements . F.29.1. The pg_stat_statements View The statistics

F.41. tsearch2

create empty database(s) and install the replacement tsearch2 module into each database that will

28.2. The Statistics Collector

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

8.3. Character Types

database is created. Regardless of the specific character set, the character with code zero (sometimes

2.1. Introduction

created a database named mydb , as described in the previous chapter, and have been able

Chapter 1. Getting Started

Creating a Database 1.4. Accessing a Database Prev   Up   Next Part I. Tutorial  Home  1.1. Installation

28.5. Dynamic Tracing

database, and relation OIDs identifying the relation. arg5 is the ID of the backend which created

50.12. pg_collation

database, it could be useful to create collations whose encoding does not match the database

CREATE INDEX

CREATE INDEX constructs an index on the specified column(s) of the specified relation, which can be a table or a materialized view. Indexes are primarily used to enhance database

CREATE SCHEMA

CREATE privilege for the current database. (Of course, superusers bypass this check.) Examples Create a schema

ALTER DEFAULT PRIVILEGES

created in the current database), or just for objects created in specified schemas. As explained

47.2. Logical Decoding Concepts

created using the streaming replication interface, a snapshot is exported (see Section 9.26.5 ), which will show exactly the state of the database

CREATE TABLE

create a new, initially empty table in the current database. The table will be owned