separate from operating system user passwords. The password for

each database user is stored in the <literal>pg_authid</literal> system

catalog. Passwords can be managed with the SQL commands

<xref linkend="sql-createuser"> and

<xref linkend="sql-createrole"> and

<xref linkend="sql-alterrole">,

e.g., <userinput>CREATEUSER foo WITH PASSWORD 'secret'</userinput>,

e.g., <userinput>CREATEROLE foo WITH LOGIN PASSWORD 'secret'</userinput>,

or the <application>psql</application>

command <literal>\password</literal>.

If no password has been set up for a user, the stored password

<para>

To create a database, you must be a superuser or have the special

<literal>CREATEDB</literal> privilege.

See <xref linkend="sql-createuser">.

See <xref linkend="sql-createrole">.

</para>

<para>

CREATE USER <replaceable>name</replaceable>;

</programlisting>

(<command>CREATE USER</command> is equivalent to <command>CREATE ROLE</command>

except that <command>CREATE USER</command>assumes <literal>LOGIN</literal> by

except that <command>CREATE USER</command>includes <literal>LOGIN</literal> by

default, while <command>CREATE ROLE</command> does not.)

</para>

</listitem>