create database - Docs search results , p.13

ALTER TYPE

recreating the enum type, or by dumping and reloading the database. Examples To rename a data

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

34.8. Internal Functions

database cluster (see Section 17.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

42.7. Database Access

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

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

37.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

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.3. Authentication Methods

database user is stored in the pg_authid system catalog. Passwords can be managed with the SQL commands CREATE

36.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

Chapter 20. Database Roles

create and manage roles. More information about the effects of role privileges on various database