create database - Docs search results , p.9

F.33. pgcrypto

CREATE privilege on the current database. F.33.1. General Hashing Functions F.33.1.1.  digest() digest(data text

5.4. Constraints

database systems.) The above example could also be written as: CREATE TABLE products ( product_no integer

F.44. pg_tsparser

create the pg_tsparser extension for each database you are planning to use: CREATE EXTENSION

65.1. Database File Layout

database can use the same CREATE TABLESPACE location value without conflicts.) Within the version-specific

CREATE FOREIGN DATA WRAPPER

creates a new foreign-data wrapper. The user who defines a foreign-data wrapper becomes its owner. The foreign-data wrapper name must be unique within the database

F.59. tcn

CREATE privilege on the current database. Only one parameter may be supplied to the function

40.10. Trigger Functions

database events. A trigger function is created with the CREATE FUNCTION command, declaring it as a function

F.8. btree_gist

CREATE privilege on the current database. F.8.1. Example Usage Simple example using btree_gist instead

DO

database by means of CREATE EXTENSION . plpgsql is installed by default, but other languages are not. The user

Chapter 45. Background Worker Processes

create and use. BGWORKER_BACKEND_DATABASE_CONNECTION Requests the ability to establish a database connection

31.21. Example Programs

database with the following commands * (provided in src/test/examples/testlibpq2.sql): * * CREATE SCHEMA TESTLIBPQ2; * SET search_path = TESTLIBPQ2

ALTER PUBLICATION

CREATE privilege on the database. Also, the new owner of a FOR ALL TABLES publication

Postgres Pro Server Applications

database server resides. Other utility programs are listed in Postgres Pro Client Applications . Table of Contents initdb — create

pg_ctl

creates a new Postgres Pro database cluster, that is, a collection of databases that will

3.6. Inheritance

database design. Let's create two tables: A table cities and a table capitals . Naturally