create database - Docs search results , p.3
Documentation >> PostgreSQL 12
CREATE COLLATION
database encoding. See CREATE DATABASE for the precise rules. Examples To create a collation from
Documentation >> PostgreSQL 12
22.1. Overview
Databases are created with the CREATE DATABASE command (see Section 22.2 ) and destroyed with the DROP
Documentation >> PostgreSQL 12
51.15. pg_database
Databases are created with the CREATE DATABASE command. Consult Chapter 22 for details about the meaning
Documentation >> PostgreSQL 12
Chapter 51. System Catalogs
CREATE DATABASE inserts a row into the pg_database catalog — and actually creates the database
Documentation >> PostgreSQL 12
ALTER DATABASE
DATABASE statement is a PostgreSQL extension. See Also CREATE DATABASE , DROP DATABASE , SET , CREATE TABLESPACE
Documentation >> PostgreSQL 12
Appendix F. Additional Supplied Modules
CREATE EXTENSION command. In a fresh database, you can simply do CREATE EXTENSION module_name
Documentation >> PostgreSQL 12
25.1. SQL Dump
database dbname will not be created by this command, so you must create it yourself
Documentation >> PostgreSQL 12
Chapter 45. PL/Python - Python Procedural Language
database, use CREATE EXTENSION plpythonu (but see also Section 45.1 ). Tip If a language is installed
Documentation >> PostgreSQL 12
5.9. Schemas
database you are connected to. So to create a table in the new schema, use: CREATE
Documentation >> PostgreSQL 12
19.15. Preset Options
database is created. lc_ctype ( string ) Reports the locale that determines character classifications. See Section
Documentation >> PostgreSQL 12
23.2. Collation Support
database system was initialized, then a new collation may be created using the CREATE COLLATION
Documentation >> PostgreSQL 12
Chapter 44. PL/Perl - Perl Procedural Language
database, use CREATE EXTENSION plperl . Tip If a language is installed into template1 , all subsequently
Documentation >> PostgreSQL 12
REINDEX
DATABASE Recreate all indexes within the current database. Indexes on shared system catalogs are also
Documentation >> PostgreSQL 12
19.11. Client Connection Defaults
database. If a nondefault tablespace is specified, the user must have CREATE privilege for it, or creation
Documentation >> PostgreSQL 12
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