create database - Docs search results , p.9

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

37.5. Query Language (SQL) Functions

creates a need for precautions when calling functions in databases where some users mistrust other

pg_standby

creation of a “ warm standby ” database server. It is designed to be a production-ready

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

33.6. Canceling Queries in Progress

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

43.11. PL/Tcl Configuration

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

GRANT

CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] } ON DATABASE database_name [, ...] TO role_specification [, ...] [ WITH GRANT

CREATE FOREIGN TABLE

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

ALTER INDEX

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

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

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

48.1. Logical Decoding Examples

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

E.11. Release 12.9

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

vacuumdb

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