CREATING ENTERPRISE SYSTEM USING POSTGRESQL (part 1)

Changing postgres user password

/#> psql -Upostgres -D template1/

/>ALTER USER postgres WITH password '[password]';/

/ alter role
/

Creating User in Postgresql

create user trade with password 'trade';

Create Database in Postgresql

create database tradeERP with owner 'trade';

create schema in Postgresql

create schema it with owner 'trade' ;
create schema trade with owner 'trade' ;
create schema hr with owner 'hr' ;

create table in Postgresql

create table [schema_Name].m_user();

or

create table "trade".m_user();

alter table m_user add column usr_Code varchar(10) not null ;

alter table m_user add column usr_name varchar(10) not null
default('noname');

alter table m_user add column usr_type smallint(10) not null defaut(1);

alter table m_user add column usr_pass varchar(20) not null defaut(1);

alter table m_user add primary key(usr_Code);