Postgres Pro
Downloads
Home

create database - Docs search results , p.3

Documentation  >>  PostgreSQL 9.4

Postgres95 Release 0.02

creating a database is 'CREATE DATABASE' instead of 'CREATEDB'. Similarly, dropping a database is 'DROP

Documentation  >>  PostgreSQL 9.4

Release 9.2.2

create to work sensibly, i.e., emit DROP DATABASE then CREATE DATABASE before reconnecting to the target

Documentation  >>  PostgreSQL 9.4

Release 8.3

create databases that have an incompatible encoding. Ensure that chr() cannot create invalidly-encoded values

Documentation  >>  PostgreSQL 9.4

pg_database

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

Documentation  >>  PostgreSQL 9.4

Additional Supplied Modules

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

Documentation  >>  PostgreSQL 9.4

System Catalogs

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

Documentation  >>  PostgreSQL 9.4

ALTER DATABASE

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

Documentation  >>  PostgreSQL 9.4

Running the Tests

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

Documentation  >>  PostgreSQL 9.4

PL/Python - Python Procedural Language

database, use CREATE EXTENSION plpythonu , or from the shell command line use createlang plpythonu dbname

Documentation  >>  PostgreSQL 9.4

SQL Dump

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

Documentation  >>  PostgreSQL 9.4

Preset Options

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

Documentation  >>  PostgreSQL 9.4

Release 9.1

CREATE EXTENSION rather than by manually invoking their SQL scripts (Dimitri Fontaine, Tom Lane) To update an existing database

Documentation  >>  PostgreSQL 9.4

CREATE EXTENSION

database: CREATE EXTENSION hstore; Update a pre-9.1 installation of hstore into extension style: CREATE

Documentation  >>  PostgreSQL 9.4

CREATE DOMAIN

created. data_type The underlying data type of the domain. This can include array specifiers. collation An optional collation for the domain. If no collation is specified, the underlying data type's default collation

Documentation  >>  PostgreSQL 9.4

Overview

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