#postgre database

How to manage PostgreSQL through command line in Ubuntu?

Step 1: First install postgres in Ubuntu system using following commands. $ sudo apt-get update $ sudo apt-get install postgresql postgresql-contrib libpq-dev To check psql (postgres) version. $  psql –version Step 2:  Now to create root user and password for psql. $  sudo -u postgres createuser -s root $  sudo -i -u  postgres Now, you are in postgres environment. postgres@admin:~$ Now, use the…