create database - Docs search results , p.6

Release 9.1.8

CREATE DATABASE and DROP DATABASE could misbehave if there were concurrent updates of pg_tablespace

Accessing a Database

Database Once you have created a database, you can access it by: Running the PostgreSQL

pg_user

create databases usesuper bool User is a superuser usecatupd bool User can update system catalogs

Release 7.0

create databases can modifying pg_database table (Peter E) Fix btree to give a useful

pg_authid

create databases rolcatupdate bool Role can update system catalogs directly. (Even a superuser cannot do this

Release 9.2.3

CREATE DATABASE and DROP DATABASE could misbehave if there were concurrent updates of pg_tablespace

CREATE SERVER

database. Creating a server requires USAGE privilege on the foreign-data wrapper being used. Parameters

pg_roles

create databases rolcatupdate bool   Role can update system catalogs directly. (Even a superuser cannot

BKI Backend Interface

creating a new database cluster. The input file used by initdb is created as part

Release 8.3.5

CREATE DATABASE starts to copy files (Heikki) This prevents a possible failure if files had recently

Release 8.0.26

CREATE DATABASE and ALTER DATABASE ... SET TABLESPACE to be interrupted by query-cancel (Guillaume Lelarge

Release 8.1.22

CREATE DATABASE and ALTER DATABASE ... SET TABLESPACE to be interrupted by query-cancel (Guillaume Lelarge

Release 7.1

CREATE DATABASE to specify template database (Tom) New utility to convert MySQL schema dumps to SQL92

CREATE CONVERSION

Also ALTER CONVERSION , CREATE FUNCTION , DROP CONVERSION Prev Home Next CREATE COLLATION Up CREATE DATABASE

pg_shadow

create databases usesuper bool   User is a superuser usecatupd bool   User can update