PostgreSQL: Difference between revisions

No edit summary
 
Line 23: Line 23:
==Users==
==Users==
<syntaxhighlight lang="postgres">
<syntaxhighlight lang="postgres">
# Create user
/* Create user */
CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypass';
CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypass';


# Give superuser
/* Give superuser */
ALTER USER myuser WITH SUPERUSER;
ALTER USER myuser WITH SUPERUSER;
</syntaxhighlight>
</syntaxhighlight>