Create user in postgres
In this tutorial, I will show you how to create user in postgres command line.
PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.
Read Also: How to install postgresql 9.6 on centos 7
Read Also: Install postgres on mac using postgres app
How to install postgresql 9.6 on Ubuntu
Create user in Postgres
I will show you how to create a user in Postgres through the command line.
postgres=# CREATE USER installvirtual;
CREATE ROLE
Read Also: How to check number of rows in postgres table
Permissions in Postgres
Give permission to user in Postgres.
postgres=# GRANT ALL ON DATABASE installvirtual TO installvirtual;
GRANT
Read Also: How to create database in postgres
Upgrade user as Super user in Postgres
Execute the following command to upgrade user as super user.
postgres=# ALTER USER installvirtual SUPERUSER;
ALTER ROLE
postgres=# \du
List of roles
Role name | Attributes | Member of
----------------+------------------------------------------------------------+-----------
installvirtual | Superuser | {}If you like the tutorial please consider sharing with your friends and colleagues.
If you get any issues in the tutorial please feel free to comment below.