create database - Docs search results , p.3

CREATE COLLATION

database encoding. See CREATE DATABASE for the precise rules. Examples To create a collation from

22.1. Overview

Databases are created with the CREATE DATABASE command (see Section 22.2 ) and destroyed with the DROP

52.15. pg_database

Databases are created with the CREATE DATABASE command. Consult Chapter 22 for details about the meaning

Chapter 52. System Catalogs

CREATE DATABASE inserts a row into the pg_database catalog — and actually creates the database

ALTER DATABASE

DATABASE statement is a PostgreSQL extension. See Also CREATE DATABASE , DROP DATABASE , SET , CREATE TABLESPACE

Appendix F. Additional Supplied Modules

CREATE EXTENSION command. In a fresh database, you can simply do CREATE EXTENSION module_name

25.1. SQL Dump

database dbname will not be created by this command, so you must create it yourself

33.1. Running the Tests

create a database called regression on the primary: psql -h primary -c "CREATE DATABASE regression

Chapter 46. PL/Python - Python Procedural Language

database, use CREATE EXTENSION plpythonu (but see also Section 46.1 ). Tip If a language is installed

5.8. Schemas

database you are connected to. So to create a table in the new schema, use: CREATE

19.15. Preset Options

database is created. lc_ctype ( string ) Reports the locale that determines character classifications. See Section

23.2. Collation Support

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

Chapter 45. PL/Perl - Perl Procedural Language

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

REINDEX

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

19.11. Client Connection Defaults

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