Search PostgreSQL documentation

CREATE USER MAPPINGSQL CommandsReferenceCREATE USER MAPPING Foreign Data 10 define a new mapping of a user to a foreign server CREATE USER MAPPING [IF NOT EXISTS] FOR { user_name | USER | CURRENT_USER | PUBLIC } SERVER server_name…SQL Commands · Foreign Data CREATE VIEWManual ChaptersPG18CREATE VIEW CREATE VIEW — define a new view Synopsis CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW name [ ( column_name [, ...] ) ] [ WITH ( view_option_name [= view_option_v…CREATE VIEW CREATE VIEWSQL CommandsReferenceCREATE VIEW Tables & Views 10 define a new view CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW name [ ( column_name [, ...] ) ] [ WITH ( view_option_name [= view_option_value]…SQL Commands · Tables & Views createdbCommand-line ToolsPG18createdb createdb — create a new PostgreSQL database Synopsis createdb [connection-option...] [option...] [dbname [description]]createdb createdbManual ChaptersPG18createdb createdb — create a new PostgreSQL database Synopsis createdb [connection-option...] [option...] [dbname [description]]createdb createdb --builtin-locale=localeCommand-line ToolsPG18--builtin-locale=locale Specifies the locale name when the builtin provider is used. Locale support is described in Section 23.1.createdb › Options createdb --echoCommand-line ToolsPG18-e--echo Echo the commands that createdb generates and sends to the server.createdb › Options createdb --encoding=encodingCommand-line ToolsPG18-E encoding--encoding=encoding Specifies the character encoding scheme to be used in this database. The character sets supported by the PostgreSQL server are described in Section 23.3.1.createdb › Options createdb --helpCommand-line ToolsPG18-?--help Show help about createdb command line arguments, and exit.createdb › Options createdb --host=hostCommand-line ToolsPG18-h host--host=host Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix domain socket.createdb › Options createdb --icu-locale=localeCommand-line ToolsPG18--icu-locale=locale Specifies the ICU locale ID to be used in this database, if the ICU locale provider is selected.createdb › Options createdb --icu-rules=rulesCommand-line ToolsPG18--icu-rules=rules Specifies additional collation rules to customize the behavior of the default collation of this database. This is supported for ICU only.createdb › Options createdb --lc-collate=localeCommand-line ToolsPG18--lc-collate=locale Specifies the LC_COLLATE setting to be used in this database.createdb › Options createdb --lc-ctype=localeCommand-line ToolsPG18--lc-ctype=locale Specifies the LC_CTYPE setting to be used in this database.createdb › Options createdb --locale-provider={builtin|libc|icu}Command-line ToolsPG18--locale-provider={builtin|libc|icu} Specifies the locale provider for the database's default collation.createdb › Options createdb --locale=localeCommand-line ToolsPG18-l locale--locale=locale Specifies the locale to be used in this database. This is equivalent to specifying --lc-collate, --lc-ctype, and --icu-locale to the same value. Some locales are onl…createdb › Options createdb --maintenance-db=dbnameCommand-line ToolsPG18--maintenance-db=dbname Specifies the name of the database to connect to when creating the new database. If not specified, the postgres database will be used; if that does not exist (or if i…createdb › Options createdb --no-passwordCommand-line ToolsPG18-w--no-password Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as a .pgpass file, the connection attempt wi…createdb › Options createdb --owner=ownerCommand-line ToolsPG18-O owner--owner=owner Specifies the database user who will own the new database. (This name is processed as a double-quoted identifier.)createdb › Options createdb --passwordCommand-line ToolsPG18-W--password Force createdb to prompt for a password before connecting to a database. This option is never essential, since createdb will automatically prompt for a password if the server de…createdb › Options createdb --port=portCommand-line ToolsPG18-p port--port=port Specifies the TCP port or the local Unix domain socket file extension on which the server is listening for connections.createdb › Options createdb --strategy=strategyCommand-line ToolsPG18-S strategy--strategy=strategy Specifies the database creation strategy. See CREATE DATABASE STRATEGY for more details.createdb › Options createdb --tablespace=tablespaceCommand-line ToolsPG18-D tablespace--tablespace=tablespace Specifies the default tablespace for the database. (This name is processed as a double-quoted identifier.)createdb › Options createdb --template=templateCommand-line ToolsPG18-T template--template=template Specifies the template database from which to build this database. (This name is processed as a double-quoted identifier.)createdb › Options createdb --username=usernameCommand-line ToolsPG18-U username--username=username User name to connect as.createdb › Options createdb --versionCommand-line ToolsPG18-V--version Print the createdb version and exit.createdb › Options createrole_self_grantConfigurationReferencecreaterole_self_grant Client Connection Defaults 16 If a user who has CREATEROLE but not SUPERUSER creates a role, and if this is set to a non-empty value, the newly-created role will be gra…Configuration · Client Connection Defaults createuserCommand-line ToolsPG18createuser createuser — define a new PostgreSQL user account Synopsis createuser [connection-option...] [option...] [username]createuser createuserManual ChaptersPG18createuser createuser — define a new PostgreSQL user account Synopsis createuser [connection-option...] [option...] [username]createuser createuser --bypassrlsCommand-line ToolsPG18--bypassrls The new user will bypass every row-level security (RLS) policy.createuser › Options createuser --connection-limit=numberCommand-line ToolsPG18-c number--connection-limit=number Set a maximum number of connections for the new user. The default is to set no limit.createuser › Options createuser --createdbCommand-line ToolsPG18-d--createdb The new user will be allowed to create databases.createuser › Options createuser --createroleCommand-line ToolsPG18-r--createrole The new user will be allowed to create, alter, drop, comment on, change the security label for other roles; that is, this user will have CREATEROLE privilege. See role creatio…createuser › Options createuser --echoCommand-line ToolsPG18-e--echo Echo the commands that createuser generates and sends to the server.createuser › Options createuser --encryptedCommand-line ToolsPG18-E--encrypted This option is obsolete but still accepted for backward compatibility.createuser › Options createuser --helpCommand-line ToolsPG18-?--help Show help about createuser command line arguments, and exit.createuser › Options createuser --host=hostCommand-line ToolsPG18-h host--host=host Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix domain socket.createuser › Options createuser --inheritCommand-line ToolsPG18-i--inherit The new role will automatically inherit privileges of roles it is a member of. This is the default.createuser › Options createuser --interactiveCommand-line ToolsPG18--interactive Prompt for the user name if none is specified on the command line, and also prompt for whichever of the options -d/-D, -r/-R, -s/-S is not specified on the command line. (This …createuser › Options createuser --loginCommand-line ToolsPG18-l--login The new user will be allowed to log in (that is, the user name can be used as the initial session user identifier). This is the default.createuser › Options