create database - Docs search results , p.10

25.2. Log-Shipping Standby Servers

create the primary and standby servers so that they are as similar as possible, at least from the perspective of the database

31.6. Canceling Queries in Progress

Creates a data structure containing the information needed to cancel a command issued through a particular database

5.4. System Columns

database-wide identifier. Of course, the tables in question must be created WITH OIDS . As of PostgreSQL

41.10. PL/Tcl Configuration

created when a PL/Tcl function is first executed in a database session, or when an additional

16.3. Installing Additional Supplied Modules

database in order to use them. In most cases, you only need to issue the CREATE

psql

database roles. (Since the concepts of “ users ” and “ groups ” have been unified into “ roles ” , this command is now equivalent to \du .) By default, only user-created

CREATE FOREIGN TABLE

creates a new foreign table in the current database. The table will be owned by the user

18.3. Connections and Authentication

database user names. It is off by default. This parameter can only be set in the postgresql.conf file or on the server command line. If this is on, you should create

ALTER INDEX

CREATE privilege on the new tablespace. All indexes in the current database in a tablespace

EXECUTE

database session. For more information on the creation and usage of prepared statements, see PREPARE

vacuumlo

database. If you use this, you may also be interested in the lo_manage trigger in the lo module. lo_manage is useful to try to avoid creating

46.1. Logical Decoding Examples

database (in the example below, postgres ) as a superuser. postgres=# -- Create a slot named 'regression

vacuumdb

database that was newly populated from a restored dump or by pg_upgrade . This option will try to create

REVOKE

CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] } ON DATABASE database_name [, ...] FROM role_specification [, ...] [ CASCADE | RESTRICT

E.31. Release 10.19

creating an ICU collation if the current database's encoding won't support it (Tom Lane