PostgreSQL DB Management

About PostgreSQL DB
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, macOS, Solaris), 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.
Database Creation
SQL to create Database named test_guru

CREATE DATABASE test_guru;
Users
SQL to create user named guru with password agile

CREATE USER guru WITH PASSWORD 'agile';
Users Permissions
SQL to grant user guru all permission on test_guru database

GRANT ALL PRIVILEGES ON DATABASE "guru" to test_guru;
Developer's portal
For all those interested in developing and reading about technology and agile practices and techniques, we have a new Developer Portal..