create database - Docs search results , p.2

Release 8.1

databases. This caused CREATE DATABASE to sometimes fail, because a new database cannot be created

Character Set Support

database cluster using initdb . It can be overridden when you create a database, so you can have

CREATE TABLESPACE

CREATE DATABASE , CREATE TABLE , CREATE INDEX or ADD CONSTRAINT to have the data files for these

Locale Support

database cluster is created using initdb . initdb will initialize the database cluster with the locale

createuser

create databases. -D --no-createdb The new user will not be allowed to create databases

Continuous Archiving and Point-in-Time Recovery (PITR)

database that the CREATE DATABASE copied is modified while the base backup is still in progress

Role Attributes

database user" . To create a role with login privilege, use either: CREATE ROLE name LOGIN

pg_dumpall

database creation will fail for databases in non-default locations. Examples To dump all databases

SHOW

database creation time. LC_COLLATE Shows the database's locale setting for collation (text ordering

sepgsql

Creating a new database object requires create permission. SELinux will grant or deny this permission

CREATE COLLATION

database encoding. (See CREATE DATABASE for the precise rules.) lc_ctype Use the specified operating

CREATE LANGUAGE

created by database owners ( tmpldbacreate is true). The default is that trusted languages can be created

Installing Procedural Languages

database template1 are automatically available in all subsequently created databases, since their entries in template1

GRANT

CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] } ON DATABASE database_name [, ...] TO { [ GROUP ] role_name | PUBLIC

Release 8.0.4

CREATE DATABASE This should fix recent reports of "index is not a btree" failures when