system-20@system20-Veriton-M4660G:~$ sudo -i -u postgres
[sudo] password for system-20: 
postgres@system20-Veriton-M4660G:~$ psql
psql (13.2 (Ubuntu 13.2-1.pgdg20.04+1))
Type "help" for help.

postgres=# \c shafeen
You are now connected to database "shafeen" as user "postgres".
shafeen=# create table sales_man((salesman_no varchar(5) primary key,s_name varchar 
shafeen(# (25)not null,place varchar(30),phone varchar(10)unique);
shafeen(# );
ERROR:  syntax error at or near "("
LINE 1: create table sales_man((salesman_no varchar(5) primary key,s...
                               ^
shafeen=# create table sales_man((salesman_no varchar(5) primary key,s_name varchar 
(25)not null,place varchar(30),phone varchar(10)unique));
ERROR:  syntax error at or near "("
LINE 1: create table sales_man((salesman_no varchar(5) primary key,s...
                               ^
shafeen=# create table sales_man(salesman_no varchar(5) primary key,s_name varchar 
(25)not null,place varchar(30),phone varchar(10)unique);
CREATE TABLE
shafeen=# select * from sales_man;
 salesman_no | s_name | place | phone 
-------------+--------+-------+-------
(0 rows)

shafeen=# create table sales_order(order_no varchar(5)primary key,order_date date not null,salesman_no varchar(5),del_type char check(del_type in('P','F')),order_status in('Inprocess','Fulfilled','Bckorder','cancelled')),foreign key (salesman_no)references sales_man(salesman_no)); 
ERROR:  syntax error at or near "in"
LINE 1: ...ype char check(del_type in('P','F')),order_status in('Inproc...
                                                             ^
shafeen=# create table sales_order(order_no varchar(5)primary key,order_date date not null,salesman_no varchar(5),del_type char check(del_type in('P','F')),order_status in ('Inprocess','Fulfilled','Bckorder','cancelled')),foreign key (salesman_no)references sales_man(salesman_no)); 
ERROR:  syntax error at or near "in"
LINE 1: ...ype char check(del_type in('P','F')),order_status in ('Inpro...
                                                             ^
shafeen=# create table sales_order(order_no varchar(5)primary key,order_date date not null,salesman_no varchar(5),del_type char check(del_type in ('P','F')),order_status in ('Inprocess','Fulfilled','Bckorder','cancelled')),foreign key (salesman_no)references sales_man(salesman_no)); 
ERROR:  syntax error at or near "in"
LINE 1: ...pe char check(del_type in ('P','F')),order_status in ('Inpro...
                                                             ^
shafeen=# create table sales_order(order_no varchar(5)primary key,order_date date not null,salesman_no varchar(5),del_type char check(del_typein('P','F')),order_statusin('Inprocess','Fulfilled','Bckorder','cancelled')),foreign key (salesman_no)references sales_man(salesman_no)); 
ERROR:  syntax error at or near "("
LINE 1: ...ype char check(del_typein('P','F')),order_statusin('Inproces...
                                                             ^
shafeen=# create table sales_order(order_no varchar(5)primary key,order_date date not null,salesman_no varchar(5),del_type char check(del_type in ('P','F')),order_status in ('Inprocess','Fulfilled','Bckorder','cancelled')),foreign key (salesman_no)references sales_man(salesman_no)); 
ERROR:  syntax error at or near "in"
LINE 1: ...pe char check(del_type in ('P','F')),order_status in ('Inpro...
                                                             ^
shafeen=# create table sales_order(order_no varchar(5)primary key,order_date date not null,salesman_no varchar(5),del_type char check(del_typein('P','F')),order_status varchar (15) check(order_status in ('Inprocess','Fulfilled','Bckorder','cancelled')),foreign key (salesman_no)references sales_man(salesman_no)); 
ERROR:  function del_typein(unknown, unknown) does not exist
LINE 1: ...t null,salesman_no varchar(5),del_type char check(del_typein...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
shafeen=# create table sales_order(order_no varchar(5)primary key,order_date date not null,salesman_no varchar(5),del_type char check (del_typein('P','F')),order_status varchar (15) check(order_status in ('Inprocess','Fulfilled','Bckorder','cancelled')),foreign key(salesman_no)references sales_man(salesman_no)); 
ERROR:  function del_typein(unknown, unknown) does not exist
LINE 1: ... null,salesman_no varchar(5),del_type char check (del_typein...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
shafeen=# create table sales_order(order_no varchar(5)primary key,order_date date not null,salesman_no varchar(5),del_type char check (del_typein('P','F')),order_status varchar (15) check(order_status in ('Inprocess','Fulfilled','Bckorder','cancelled')),foreign key(salesman_no)references salesman(salesman_no)); 
ERROR:  function del_typein(unknown, unknown) does not exist
LINE 1: ... null,salesman_no varchar(5),del_type char check (del_typein...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
shafeen=# create table sales_order(order_no varchar(5) primary key,order_date date not null,salesman_no varchar(5),del_type char check(del_type in('P','F')),order_status varchar(15) check(order_status in ('Inprocess','Fulfilled','Bckorder','cancelled')),foreign key(salesman_no) references salesman(salesman_no)); 
ERROR:  relation "salesman" does not exist
shafeen=# \d salesman;
Did not find any relation named "salesman".
shafeen=# \d sales_man;
                       Table "public.sales_man"
   Column    |         Type          | Collation | Nullable | Default 
-------------+-----------------------+-----------+----------+---------
 salesman_no | character varying(5)  |           | not null | 
 s_name      | character varying(25) |           | not null | 
 place       | character varying(30) |           |          | 
 phone       | character varying(10) |           |          | 
Indexes:
    "sales_man_pkey" PRIMARY KEY, btree (salesman_no)
    "sales_man_phone_key" UNIQUE CONSTRAINT, btree (phone)

shafeen=# create table sales_order(order_no varchar(5) primary key,order_date date not null,salesman_no varchar(5),del_type char check(del_type in('P','F')),order_status varchar(15) check(order_status in ('Inprocess','Fulfilled','Bckorder','cancelled')),foreign key(salesman_no) references sales_man(salesman_no)); 
CREATE TABLE
shafeen=# insert into sales_man values(100,'aby','thamarassery','112232');
INSERT 0 1
shafeen=# insert into sales_man values(101,'mithilaj','maloram','1122332');
INSERT 0 1
shafeen=# insert into sales_man values(102,'henna','karady','11224332');
INSERT 0 1
shafeen=# insert into sales_man values(102,'shahana','kaithapoyil','11232');
ERROR:  duplicate key value violates unique constraint "sales_man_pkey"
DETAIL:  Key (salesman_no)=(102) already exists.
shafeen=# insert into sales_man values(103,'shahana','kaithapoyil','11232');
INSERT 0 1
shafeen=# insert into sales_man values(104','shafeen'nooramthode','1155232');
ERROR:  syntax error at or near "','"
LINE 1: insert into sales_man values(104','shafeen'nooramthode','115...
                                        ^
shafeen=# insert into sales_man values('104','shafeen'nooramthode','1155232');
shafeen'# insert into sales_man values(104','shafeen','nooramthode','1155232');
ERROR:  syntax error at or near "nooramthode"
LINE 1: insert into sales_man values('104','shafeen'nooramthode','11...
                                                    ^
shafeen=# insert into sales_man values('104','shafeen'nooramthode','1155232');
insert into sales_man values(104','shafeen','nooramthode','1155232');
ERROR:  syntax error at or near "nooramthode"
LINE 1: insert into sales_man values('104','shafeen'nooramthode','11...
                                                    ^
shafeen=# insert into sales_man values(103,'shafeen','nooramthode','11423232');
ERROR:  duplicate key value violates unique constraint "sales_man_pkey"
DETAIL:  Key (salesman_no)=(103) already exists.
shafeen=# insert into sales_man values(104,'shafeen','nooramthode','11423232');
INSERT 0 1
shafeen=# select * from sales_man;
 salesman_no |  s_name  |    place     |  phone   
-------------+----------+--------------+----------
 100         | aby      | thamarassery | 112232
 101         | mithilaj | maloram      | 1122332
 102         | henna    | karady       | 11224332
 103         | shahana  | kaithapoyil  | 11232
 104         | shafeen  | nooramthode  | 11423232
(5 rows)

shafeen=# \d sales_man;
                       Table "public.sales_man"
   Column    |         Type          | Collation | Nullable | Default 
-------------+-----------------------+-----------+----------+---------
 salesman_no | character varying(5)  |           | not null | 
 s_name      | character varying(25) |           | not null | 
 place       | character varying(30) |           |          | 
 phone       | character varying(10) |           |          | 
Indexes:
    "sales_man_pkey" PRIMARY KEY, btree (salesman_no)
    "sales_man_phone_key" UNIQUE CONSTRAINT, btree (phone)
Referenced by:
    TABLE "sales_order" CONSTRAINT "sales_order_salesman_no_fkey" FOREIGN KEY (salesman_no) REFERENCES sales_man(salesman_no)

shafeen=# select * from sales_man;
 salesman_no |  s_name  |    place     |  phone   
-------------+----------+--------------+----------
 100         | aby      | thamarassery | 112232
 101         | mithilaj | maloram      | 1122332
 102         | henna    | karady       | 11224332
 103         | shahana  | kaithapoyil  | 11232
 104         | shafeen  | nooramthode  | 11423232
(5 rows)

shafeen=# alter table sales_man drop constraints