create database - Docs search results , p.9

9.26. System Administration Functions

database (which is granted by default). To use pg_tablespace_size , you must have CREATE

E.16. Release 9.6.9

creating a minor security issue. After installing this update, administrators should update adminpack by performing ALTER EXTENSION adminpack UPDATE in each database

EXECUTE

database session. For more information on the creation and usage of prepared statements, see PREPARE

vacuumlo

database. If you use this, you may also be interested in the lo_manage trigger in the lo module. lo_manage is useful to try to avoid creating

vacuumdb

database that was newly populated from a restored dump or by pg_upgrade . This option will try to create

47.1. Logical Decoding Examples

database (in the example below, postgres ) as a superuser. postgres=# -- Create a slot named 'regression

REVOKE

CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] } ON DATABASE database_name [, ...] FROM role_specification [, ...] [ CASCADE | RESTRICT

50.64. pg_indexes

database) indexdef text   Index definition (a reconstructed CREATE INDEX command) Prev   Up   Next 50.63.  pg_group

50.54. pg_ts_template

creation of new templates is restricted to database superusers. PostgreSQL 's text search features are described

50.53. pg_ts_parser

creation of new parsers is restricted to database superusers. PostgreSQL 's text search features are described

CREATE TYPE

CREATE TYPE registers a new data type for use in the current database. The user

11.2. Index Types

database does not use the C locale you will need to create the index with

CREATE EVENT TRIGGER

creates an event trigger becomes its owner. Parameters name The name to give the new trigger. This name must be unique within the database

5.10. Partitioning

database server. Currently, PostgreSQL supports partitioning via table inheritance. Each partition must be created as a child

41.1. Overview

database system. The design goals of PL/pgSQL were to create a loadable procedural language that