create database - Docs search results , p.12

G.2. Server Applications

database cluster and compatibility information for a cluster and/or server pg_standby — supports the creation

6.1. Inserting Data

created, it contains no data. The first thing to do before a database can be of much

F.39. pg_hint_plan

DATABASE SET for automatic loading for specific sessions. postgres=# LOAD 'pg_hint_plan'; LOAD postgres=# Do CREATE

37.8. Internal Functions

database cluster (see Section 18.2 ), but a user could use CREATE FUNCTION to create additional

Part II. The SQL Language

create the structures to hold data, how to populate the database, and how to query

Appendix K. Acronyms

Database Management System DDL Data Definition Language , SQL commands such as CREATE TABLE , ALTER USER

8.18. Object Identifier Types

databases, or even in large individual tables. So, using a user-created table's OID column

11.2. Index Types

database does not use the C locale you will need to create the index with

45.7. Database Access

created by plpy.cursor with DB-API cursors as defined by the Python Database API specification

40.4. Rules on INSERT, UPDATE, and DELETE

database. To make it a little harder for Postgres Pro , we don't delete it directly. Instead we create

11.3. Multicolumn Indexes

CREATE TABLE test2 ( major int, minor int, name varchar ); (say, you keep your /dev directory in a database

CREATE FUNCTION

CREATE TRANSFORM . Procedural language implementations usually have hardcoded knowledge of the built-in types, so those don't need to be listed here. If a procedural language implementation does not know how to handle

9.25. System Information Functions

database in a particular way. Its argument possibilities are analogous to has_table_privilege . The desired access privilege type must evaluate to some combination of CREATE

19.8. Error Reporting and Logging

CREATE TABLE postgres_log ( log_time timestamp(3) with time zone, user_name text, database

39.1. Overview of Event Trigger Behavior

database in which it is defined. Currently, the only supported events are ddl_command_start , ddl_command_end , table_rewrite and sql_drop . Support for additional events may be added in future releases