In this topic we will base on this table of users :
CREATE TABLE sch_test.user_table
(
id serial NOT NULL,
username character varying,
pass character varying,
first_name character varying(30),
last_name character varying(30),
CONSTRAINT user_table_pkey PRIMARY KEY (id)
)
+---...