createuser

options

map[description: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 others. Multiple existing roles can be specified by writing multiple -a switches. names:[-a role --with-admin= role] signature:-a role --with-admin= role source_url:/docs/18/app-createuser.html summary: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 others. Multiple existing roles can be specified by writing multiple -a switches.], map[description:Set a maximum number of connections for the new user. The default is to set no limit. names:[-c number --connection-limit= number] signature:-c number --connection-limit= number source_url:/docs/18/app-createuser.html summary:Set a maximum number of connections for the new user. The default is to set no limit.], map[description:The new user will be allowed to create databases. names:[-d --createdb] signature:-d --createdb source_url:/docs/18/app-createuser.html summary:The new user will be allowed to create databases.], map[description:The new user will not be allowed to create databases. This is the default. names:[-D --no-createdb] signature:-D --no-createdb source_url:/docs/18/app-createuser.html summary:The new user will not be allowed to create databases. This is the default.], map[description:Echo the commands that createuser generates and sends to the server. names:[-e --echo] signature:-e --echo source_url:/docs/18/app-createuser.html summary:Echo the commands that createuser generates and sends to the server.], map[description:This option is obsolete but still accepted for backward compatibility. names:[-E --encrypted] signature:-E --encrypted source_url:/docs/18/app-createuser.html summary:This option is obsolete but still accepted for backward compatibility.], map[description:Specifies the new role should be automatically added as a member of the specified existing role. Multiple existing roles can be specified by writing multiple -g switches. names:[-g role --member-of= role --role= role] signature:-g role --member-of= role --role= role (deprecated) source_url:/docs/18/app-createuser.html summary:Specifies the new role should be automatically added as a member of the specified existing role. Multiple existing roles can be specified by writing multiple -g switches.], map[description:The new role will automatically inherit privileges of roles it is a member of. This is the default. names:[-i --inherit] signature:-i --inherit source_url:/docs/18/app-createuser.html summary:The new role will automatically inherit privileges of roles it is a member of. This is the default.], map[description:The new role will not automatically inherit privileges of roles it is a member of. names:[-I --no-inherit] signature:-I --no-inherit source_url:/docs/18/app-createuser.html summary:The new role will not automatically inherit privileges of roles it is a member of.], map[description: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 was the default behavior up to PostgreSQL 9.1.) names:[--interactive] signature:--interactive source_url:/docs/18/app-createuser.html summary: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 was the default behavior up to PostgreSQL 9.1.)], map[description: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. names:[-l --login] signature:-l --login source_url:/docs/18/app-createuser.html summary: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.], map[description: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.) names:[-L --no-login] signature:-L --no-login source_url:/docs/18/app-createuser.html summary: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.)], map[description: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. names:[-m role --with-member= role] signature:-m role --with-member= role source_url:/docs/18/app-createuser.html summary: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.], map[description: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. names:[-P --pwprompt] signature:-P --pwprompt source_url:/docs/18/app-createuser.html summary: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.], map[description: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 creation for more details about what capabilities are conferred by this privilege. names:[-r --createrole] signature:-r --createrole source_url:/docs/18/app-createuser.html summary: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 creation for more details about what capabilities are conferred by this privilege.], map[description:The new user will not be allowed to create new roles. This is the default. names:[-R --no-createrole] signature:-R --no-createrole source_url:/docs/18/app-createuser.html summary:The new user will not be allowed to create new roles. This is the default.], map[description:The new user will be a superuser. names:[-s --superuser] signature:-s --superuser source_url:/docs/18/app-createuser.html summary:The new user will be a superuser.], map[description:The new user will not be a superuser. This is the default. names:[-S --no-superuser] signature:-S --no-superuser source_url:/docs/18/app-createuser.html summary:The new user will not be a superuser. This is the default.], map[description:Set a date and time after which the role's password is no longer valid. The default is to set no password expiry date. names:[-v timestamp --valid-until= timestamp] signature:-v timestamp --valid-until= timestamp source_url:/docs/18/app-createuser.html summary:Set a date and time after which the role's password is no longer valid. The default is to set no password expiry date.], map[description:Print the createuser version and exit. names:[-V --version] signature:-V --version source_url:/docs/18/app-createuser.html summary:Print the createuser version and exit.], map[description:The new user will bypass every row-level security (RLS) policy. names:[--bypassrls] signature:--bypassrls source_url:/docs/18/app-createuser.html summary:The new user will bypass every row-level security (RLS) policy.], map[description:The new user will not bypass row-level security (RLS) policies. This is the default. names:[--no-bypassrls] signature:--no-bypassrls source_url:/docs/18/app-createuser.html summary:The new user will not bypass row-level security (RLS) policies. This is the default.], map[description:The new user will have the REPLICATION privilege, which is described more fully in the documentation for CREATE ROLE . names:[--replication] signature:--replication source_url:/docs/18/app-createuser.html summary:The new user will have the REPLICATION privilege, which is described more fully in the documentation for CREATE ROLE .], map[description:The new user will not have the REPLICATION privilege, which is described more fully in the documentation for CREATE ROLE . This is the default. names:[--no-replication] signature:--no-replication source_url:/docs/18/app-createuser.html summary:The new user will not have the REPLICATION privilege, which is described more fully in the documentation for CREATE ROLE . This is the default.], map[description:Show help about createuser command line arguments, and exit. names:[-? --help] signature:-? --help source_url:/docs/18/app-createuser.html summary:Show help about createuser command line arguments, and exit.], map[description: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. names:[-h host --host= host] signature:-h host --host= host source_url:/docs/18/app-createuser.html summary: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.], map[description:Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections. names:[-p port --port= port] signature:-p port --port= port source_url:/docs/18/app-createuser.html summary:Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections.], map[description:User name to connect as (not the user name to create). names:[-U username --username= username] signature:-U username --username= username source_url:/docs/18/app-createuser.html summary:User name to connect as (not the user name to create).], map[description: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 will fail. This option can be useful in batch jobs and scripts where no user is present to enter a password. names:[-w --no-password] signature:-w --no-password source_url:/docs/18/app-createuser.html summary: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 will fail. This option can be useful in batch jobs and scripts where no user is present to enter a password.], map[description: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 automatically prompt for a password if the server demands password authentication. However, createuser will waste a connection attempt finding out that the server wants a password. In some cases it is worth typing -W to avoid the extra connection attempt. names:[-W --password] signature:-W --password source_url:/docs/18/app-createuser.html summary:Force createuser to prompt for a password (for connecting to the server, not for the password of the new user).]