PostgreSQL: Difference between revisions
No edit summary |
|||
| Line 23: | Line 23: | ||
==Users== | ==Users== | ||
<syntaxhighlight lang="postgres"> | <syntaxhighlight lang="postgres"> | ||
/* Create user */ | |||
CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypass'; | CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypass'; | ||
/* Give superuser */ | |||
ALTER USER myuser WITH SUPERUSER; | ALTER USER myuser WITH SUPERUSER; | ||
</syntaxhighlight> | </syntaxhighlight> | ||