Create PostgreSQL user and database - Tutorial | The Dev Tool | Toolel.com

First you need to create a user. You can create a username toolel and password helloworld123 by

CREATE USER toolel WITH PASSWORD 'helloworld123';

After this we can create an database that the user can use:

CREATE DATABASE tooleldb;

But this wont be so useful unless the user gets privileges on the database:

GRANT ALL PRIVILEGES ON DATABASE tooleldb to toolel;

This grants all privileges for the database, but PostgreSQL have many more ways to give certain rights and not others.

Created by: martin

Comments

This page is only partially working without JavaScript. It will show content, but the tools and interactivity cannot be shown without JavaScript enabled. Please enable JavaScript for this page. About Us