create database - Docs search results , p.8
Documentation >> Postgres Pro Standard 13
ALTER DEFAULT PRIVILEGES
created in the current database), or just for objects created in specified schemas. As explained
Documentation >> Postgres Pro Standard 13
CREATE INDEX
CREATE INDEX constructs an index on the specified column(s) of the specified relation, which can be a table or a materialized view. Indexes are primarily used to enhance database
Documentation >> Postgres Pro Standard 13
pg_upgrade
database schemas, and not user data. For deployment testing, create a schema-only copy of the old cluster
Documentation >> Postgres Pro Standard 13
CREATE SUBSCRIPTION
CREATE SUBSCRIPTION adds a new subscription for the current database. The subscription name must be distinct
Documentation >> Postgres Pro Standard 13
42.5. Trusted and Untrusted PL/Perl
database superusers to create functions in untrusted languages. If the above function was created by a superuser
Documentation >> Postgres Pro Standard 13
29.7. Security
CREATE privilege in the database. To add tables to a publication, the user must have
Documentation >> Postgres Pro Standard 13
17.6. Upgrading a Postgres Pro Cluster
Create a new database cluster if needed. Remember that you must execute these commands while
Documentation >> Postgres Pro Standard 13
9.26. System Information Functions and Operators
database? Allowable privilege types are CREATE , CONNECT , TEMPORARY , and TEMP (which is equivalent to TEMPORARY
Documentation >> Postgres Pro Standard 13
50.4. Streaming Replication Protocol
created in a database other than the database the walsender is connected to, this command
Documentation >> Postgres Pro Standard 13
CREATE TABLE
create a new, initially empty table in the current database. The table will be owned
Documentation >> Postgres Pro Standard 13
49.49. pg_statistic
database. Entries are created by ANALYZE and subsequently used by the query planner. Note that
Documentation >> Postgres Pro Standard 13
24.2. File System Level Backup
database server is running. However, a backup created in this way saves the database files
Documentation >> Postgres Pro Standard 13
PREPARE
database session. When the session ends, the prepared statement is forgotten, so it must be recreated
Documentation >> Postgres Pro Standard 13
CREATE STATISTICS
created in the current database and will be owned by the user issuing the command
Documentation >> Postgres Pro Standard 13
25.5. Hot Standby
database using PL functions will still be possible, even though the transaction is read-only locally. The following types of administration commands are not accepted during recovery mode: Data Definition Language (DDL): e.g., CREATE