Search “alter_database” — BetterMan

Search

Tip: Use ssh_config or systemd.unit for dotted names.

Did you mean: drop_database, create_database, alter_table, alter_domain?

change a database

NAME ALTER_DATABASE - change a database SYNOPSIS ALTER DATABASE name [ [ WITH ] option [ ... ] ] where option ... CONNECTION LIMIT connlimit IS_TEMPLATE istemplate ALTER DATABASE n…

create_database(7)

create a new database

specific database, you can use ALTER DATABASE ... SET. lc_collate Sets LC_COLLATE ... from an existing installation. See also ALTER DATABASE ( ALTER_DATABASE (7)) for how to handle

alter_role(7)

change a database role

same as using the command ALTER DATABASE ... SET .... Whenever the role subsequently starts ... rather than to a role; see ALTER DATABASE ( ALTER_DATABASE (7)). If there

reassign_owned(7)
change the ownership of database objects owned by a database role
```
DROP ROLE ( DROP_ROLE (7)), ALTER DATABASE ( ALTER_DATABASE
```

alter_table(7)

change the definition of a table

moved by this command; use ALTER DATABASE or explicit ALTER TABLE invocations instead if desired

alter_index(7)

change the definition of an index

moved by this command, use ALTER DATABASE or explicit ALTER INDEX invocations instead if desired

alter_collation(7)

change the definition of a collation

collation, there is an analogous command ALTER DATABASE ... REFRESH COLLATION VERSION. The following query

pg_dump(1)

extract a PostgreSQL database into a script file or other archive file

this database, that is, any ALTER DATABASE ... SET ... and ALTER ROLE ... IN DATABASE ... SET ... commands

pg_restore(1)

restore a PostgreSQL database from an archive file created by pg_dump

this database, that is, any ALTER DATABASE ... SET ... and ALTER ROLE ... IN DATABASE ... SET ... commands

psql(1)

PostgreSQL interactive terminal

specific, respectively. The ALTER ROLE and ALTER DATABASE commands are used to define per-role

set_role(7)

set the current user identifier of the current session

command-line options, ALTER ROLE , or ALTER DATABASE , if any such settings exist. Otherwise, RESET

set_transaction(7)

set the characteristics of the current transaction

configuration file, via ALTER DATABASE , etc. Consult Chapter 19 for more information. The current transaction

mariadb-binlog(1)
utility for processing binary log files (mariadb-binlog is now a symlink to mariadb-binlog)
```
exception for CREATE DATABASE, ALTER DATABASE, and DROP DATABASE. The database being created, altered
```
drop_database(7)
remove a database
```
NAME DROP_DATABASE
```
drop_role(7)
remove a database role
```
NAME DROP_ROLE
```
drop_user(7)
remove a database role
```
NAME DROP_USER
```
drop_group(7)
remove a database role
```
NAME DROP_GROUP
```
clusterdb(1)
cluster a PostgreSQL database
```
NAME clusterdb - cluster
```
ucfq(1)
query ucf database
```
NAME ucfq - query
```
alter_user(7)
change a database role
```
NAME ALTER_USER
```

20 results loaded