How to manage PostgreSQL through command line in Ubuntu?
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…
View On WordPress









