PostgreSQL: Difference between revisions

No edit summary
Line 14: Line 14:
==Users==
==Users==
<syntaxhighlight lang="postgres">
<syntaxhighlight lang="postgres">
# Create user
CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypass';
CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypass';
ALTER USER david WITH SUPERUSER;
 
# Give superuser
ALTER USER myuser WITH SUPERUSER;
</syntaxhighlight>
</syntaxhighlight>