create database - Docs search results , p.4

18.15. Preset Options

database is created. lc_collate_canonical ( string ) Reports the canonical name of the collation order

22.2. Collation Support

database system was initialized, then a new collation may be created using the CREATE COLLATION

Chapter 42. PL/Perl — Perl Procedural Language

database, use CREATE EXTENSION plperl . Tip If a language is installed into template1 , all subsequently

CREATE LANGUAGE

database, which will cause it to be available automatically in all subsequently-created databases. Examples

REINDEX

DATABASE Recreate all indexes within the current database. Indexes on shared system catalogs are also

18.11. Client Connection Defaults

database. If a nondefault tablespace is specified, the user must have CREATE privilege for it, or creation

pgbench

database sessions. The default TPC-B-like transaction test requires specific tables to be set up beforehand. pgbench should be invoked with the -i (initialize) option to create

Part III. Server Administration

Creating a Database Cluster 17.3. Starting the Database Server 17.4. Managing Kernel Resources 17.5. Shutting

18.5. Write Ahead Log

database will be thrown away and recreated, or for a read-only database clone which

49.1. Overview

database creation and are thereafter database-specific. A few catalogs are physically shared across all databases

pg_basebackup

database.) To create a backup of a local database where the tablespace in /opt/ts is relocated

psql

database roles. (Since the concepts of “ users ” and “ groups ” have been unified into “ roles ” , this command is now equivalent to \du .) By default, only user-created

F.35. pg_pathman

databases where extensions issuing CREATE POLICY statements are installed. Therefore, when restoring a dump of a database

DROP DATABASE

DATABASE statement in the SQL standard. See Also CREATE DATABASE Prev   Up   Next DROP CONVERSION

pg_repack

database when the --all option is specified. Create the pg_repack extension in the database