Search PostgreSQL documentation

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 createuserCommand-line ToolsPG18createuser 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 createuser --no-bypassrlsCommand-line ToolsPG18--no-bypassrls The new user will not bypass row-level security (RLS) policies. This is the default.createuser › Options createuser --no-createdbCommand-line ToolsPG18-D--no-createdb The new user will not be allowed to create databases. This is the default.createuser › Options createuser --no-createroleCommand-line ToolsPG18-R--no-createrole The new user will not be allowed to create new roles. This is the default.createuser › Options createuser --no-inheritCommand-line ToolsPG18-I--no-inherit The new role will not automatically inherit privileges of roles it is a member of.createuser › Options createuser --no-loginCommand-line ToolsPG18-L--no-login The new user will not be allowed to log in. (A role without login privilege is still useful as a means of managing database permissions.)createuser › Options createuser --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…createuser › Options createuser --no-replicationCommand-line ToolsPG18--no-replication The new user will not have the REPLICATION privilege, which is described more fully in the documentation for CREATE ROLE. This is the default.createuser › Options createuser --no-superuserCommand-line ToolsPG18-S--no-superuser The new user will not be a superuser. This is the default.createuser › Options createuser --passwordCommand-line ToolsPG18-W--password Force createuser to prompt for a password (for connecting to the server, not for the password of the new user). This option is never essential, since createuser will automatical…createuser › Options createuser --port=portCommand-line ToolsPG18-p port--port=port Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections.createuser › Options createuser --pwpromptCommand-line ToolsPG18-P--pwprompt If given, createuser will issue a prompt for the password of the new user. This is not necessary if you do not plan on using password authentication.createuser › Options createuser --replicationCommand-line ToolsPG18--replication The new user will have the REPLICATION privilege, which is described more fully in the documentation for CREATE ROLE.createuser › Options createuser --role=roleCommand-line ToolsPG18-g role--member-of=role--role=role (deprecated) Specifies the new role should be automatically added as a member of the specified existing role. Multiple existing roles can be specified by w…createuser › Options createuser --superuserCommand-line ToolsPG18-s--superuser The new user will be a superuser.createuser › Options createuser --username=usernameCommand-line ToolsPG18-U username--username=username User name to connect as (not the user name to create).createuser › Options createuser --valid-until=timestampCommand-line ToolsPG18-v timestamp--valid-until=timestamp Set a date and time after which the role's password is no longer valid. The default is to set no password expiry date.createuser › Options createuser --versionCommand-line ToolsPG18-V--version Print the createuser version and exit.createuser › Options createuser --with-admin=roleCommand-line ToolsPG18-a role--with-admin=role Specifies an existing role that will be automatically added as a member of the new role with admin option, giving it the right to grant membership in the new role to…createuser › Options createuser --with-member=roleCommand-line ToolsPG18-m role--with-member=role Specifies an existing role that will be automatically added as a member of the new role. Multiple existing roles can be specified by writing multiple -m switches.createuser › Options dbnameCommand-line ToolsPG18dbname The database name. Defaults to be the same as the user name. In certain contexts, the value is checked for extended formats; see Section 32.1.1 for more details on those.Database Connection Control Functions › Parameter Key Words dropdbCommand-line ToolsPG18dropdb dropdb — remove a PostgreSQL database Synopsis dropdb [connection-option...] [option...] dbnamedropdb dropdb --echoCommand-line ToolsPG18-e--echo Echo the commands that dropdb generates and sends to the server.dropdb › Options dropdb --forceCommand-line ToolsPG18-f--force Attempt to terminate all existing connections to the target database before dropping it. See DROP DATABASE for more information on this option.dropdb › Options dropdb --helpCommand-line ToolsPG18-?--help Show help about dropdb command line arguments, and exit.dropdb › Options dropdb --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.dropdb › Options dropdb --if-existsCommand-line ToolsPG18--if-exists Do not throw an error if the database does not exist. A notice is issued in this case.dropdb › Options