create database - Docs search results , p.3

Chapter 49. 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

24.1. SQL Dump

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

30.1. Running the Tests

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

Chapter 43. PL/Python - Python Procedural Language

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

5.8. Schemas

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

18.15. Preset Options

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

Chapter 42. PL/Perl - Perl Procedural Language

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

REINDEX

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

18.11. Client Connection Defaults

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

createlang

created databases as well. See Also droplang , CREATE EXTENSION , CREATE LANGUAGE Prev   Up   Next createdb

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

22.2. Collation Support

database cannot be changed after its creation. 22.2.1. Concepts Conceptually, every expression of a collatable

Part III. Server Administration

Creating a Database Cluster 17.3. Starting the Database Server 17.4. Managing Kernel Resources 17.5. Shutting