Guide install postgresql on ubuntu

Guide install postgresql on ubuntu
ok before i start with my guide i go to explain how we can install postgresql on ubuntu and create name database and create TABLE
i epxlain slow slow and step by step.........
step1
we need inside to Terminal and write like this

this the commands you need to install

Code:


sudo apt-get install postgresql postgresql-client postgresql-common


step2
after you install postgresql in your system then now you need also create database and you need doing like this

if  you see you have two commands and it this

Code:


sudo su postgres
psql


afther you write two commands you can see you inside to options create new Database this look like this

like you see this commands for Create New database

Code:


CREATE DATABASE mircx;


for look list of Databases you can write like this

step3
you can also create TABLE nember if you dont know how this working then its look like this

this mean you can copy this and put your name psql

Code:


psql mircx
CREATE TABLE member (
name varchar(80),
last varchar(80),
birthdate date
);


step4
you can CREATE in you psql  Separate Roles you can see in here all options what you have

the commands for create you can write like this

Code:


CREATE ROLE login_mircx WITH login;
\du


after you doing this you can see in picture your create roles

step5
if you want create password you need make like this

Code:


sudo -u postgres psql mircx
\password postgres


more something important if you want remove your database what you Create then you need doing like this

Code:


dropdb mircx


for question
mircx123@gmail.com
Good luck
Guide By MIRCX
The community old