EN
PostgreSQL example tables
0 points
xxxxxxxxxx1
DROP TABLE IF EXISTS "users";2
CREATE TABLE "users" (3
"id" SERIAL,4
"name" VARCHAR(100) NOT NULL,5
"country" VARCHAR(15) NOT NULL,6
PRIMARY KEY ("id")7
);xxxxxxxxxx1
INSERT INTO "users"2
("name", "country")3
VALUES4
('Tom', 'Poland'),5
('Chris', 'Spain'),6
('Jack', 'Spain'),7
('Kim', 'Vietnam'),8
('Marco', 'Italy'),9
('Kate', 'Spain'),10
('Nam', 'Vietnam');
xxxxxxxxxx1
DROP TABLE IF EXISTS "users";2
CREATE TABLE "users" (3
"id" SERIAL,4
"name" VARCHAR(50) NOT NULL,5
"surname" VARCHAR(50) NOT NULL,6
"email" VARCHAR(50),7
PRIMARY KEY ("id")8
);xxxxxxxxxx1
INSERT INTO "users"2
( "name", "surname", "email")3
VALUES4
('John', 'Stewart', 'john@email.com'),5
('Chris', 'Brown', ''),6
('Kate', 'Lewis',''),7
('Ailisa', 'Gomez', 'ailisa@email.com'),8
('Gwendolyn', 'James', NULL),9
('Simon', 'Collins', NULL),10
('Taylor', 'Martin',NULL),11
('Andrew', 'Thompson', 'andrew123@email.com');
xxxxxxxxxx1
DROP TABLE IF EXISTS "users";2
CREATE TABLE "users" (3
"id" SERIAL,4
"name" VARCHAR(100) NOT NULL,5
"email" VARCHAR(100) NOT NULL,6
"country" VARCHAR(15) NOT NULL,7
PRIMARY KEY ("id")8
);xxxxxxxxxx1
INSERT INTO "users"2
("name", "email", "country")3
VALUES4
('Tom', 'tom@email.com', 'Poland'),5
('Chris', 'chris@email.com', 'Spain'),6
('Jack', 'jack@email.com', 'Spain'),7
('Kim', 'kim@email.com', 'Vietnam'),8
('Marco', 'marco@email.com', 'Italy'),9
('Kate', 'kate@email.com', 'Spain'),10
('Nam', 'nam@email.com', 'Vietnam');
xxxxxxxxxx1
DROP TABLE IF EXISTS "users";2
CREATE TABLE "users" (3
"id" SERIAL,4
"name" VARCHAR(50) NOT NULL,5
"surname" VARCHAR(50) NOT NULL,6
"email" VARCHAR(50),7
PRIMARY KEY ("id")8
);xxxxxxxxxx1
INSERT INTO "users"2
( "name", "surname", "email")3
VALUES4
('John', 'Stewart', 'john@email.com'),5
('Chris', 'Brown', NULL),6
('Kate', 'Lewis', NULL),7
('Ailisa', 'Gomez', 'ailisa@email.com'),8
('Gwendolyn', 'James', NULL),9
('Simon', 'Collins', NULL),10
('Taylor', 'Martin', NULL),11
('Andrew', 'Thompson', 'andrew@email.com');
xxxxxxxxxx1
DROP TABLE IF EXISTS "users";2
CREATE TABLE "users" (3
"id" SERIAL,4
"name" VARCHAR(100) NOT NULL,5
"email" VARCHAR(100) NOT NULL,6
"country" VARCHAR(15) NOT NULL,7
PRIMARY KEY ("id")8
);xxxxxxxxxx1
INSERT INTO "users"2
( "name", "surname", "email")3
VALUES4
('John', 'Stewart', 'john@email.com'),5
('Chris', 'Brown', NULL),6
('Kate', 'Lewis', NULL),7
('Ailisa', 'Gomez', 'ailisa@email.com'),8
('Gwendolyn', 'James', NULL),9
('Simon', 'Collins', NULL),10
('Taylor', 'Martin', NULL),11
('Andrew', 'Thompson', 'andrew@email.com');
xxxxxxxxxx1
DROP TABLE IF EXISTS "users";2
CREATE TABLE "users" (3
"id" SERIAL,4
"name" VARCHAR(50) NOT NULL,5
"surname" VARCHAR(50) NOT NULL,6
"department_id" INTEGER,7
"salary" DECIMAL(15,2) NOT NULL,8
PRIMARY KEY ("id")9
);xxxxxxxxxx1
INSERT INTO "users"2
( "name", "surname", "department_id", "salary")3
VALUES4
('John', 'Stewart', 1, '2000.00'),5
('Chris', 'Brown', 3, '2000.00'),6
('Chris', 'Lewis', 3, '2000.00'),7
('Kate', 'Lewis', 3, '2000.00'),8
('Kate', 'Stewart', 3, '2000.00'),9
('Ailisa', 'Lewis', 3, '2000.00'),10
('Ailisa', 'Gomez', 3, '3000.00'),11
('Gwendolyn', 'James', 2, '3000.00'),12
('Simon', 'James', 2, '2000.00'),13
('Simon', 'Brown', 3, '2000.00'),14
('Simon', 'Collins', 3, '3000.00');
xxxxxxxxxx1
DROP TABLE IF EXISTS "users";2
CREATE TABLE "users" (3
"id" SERIAL,4
"name" VARCHAR(50) NOT NULL,5
"surname" VARCHAR(50) NOT NULL,6
"department_id" INTEGER,7
"salary" DECIMAL(15,2) NOT NULL,8
PRIMARY KEY ("id")9
);xxxxxxxxxx1
INSERT INTO "users"2
( "name", "surname", "department_id", "salary")3
VALUES4
('John', 'Stewart', 1, '3512.00'),5
('Chris', 'Brown', 2, '1344.00'),6
('Kate', 'Lewis', 3, '6574.00'),7
('Ailisa', 'Gomez', NULL, '6500.00'),8
('Gwendolyn', 'James', 2, '4200.00'),9
('Simon', 'Cousersllins', 4, '3320.00'),10
('Taylor', 'Martin', 2, '1500.00'),11
('Andrew', 'Thompson', NULL, '2100.00');
xxxxxxxxxx1
DROP TABLE IF EXISTS "users";2
CREATE TABLE "users" (3
"id" SERIAL,4
"name" VARCHAR(50) NOT NULL,5
"surname" VARCHAR(50) NOT NULL,6
"email" VARCHAR(50),7
PRIMARY KEY ("id")8
);xxxxxxxxxx1
INSERT INTO "users"2
( "name", "surname", "email")3
VALUES4
('John', 'Stewart', 'john@email.com'),5
('Chris', 'Brown', ''),6
('Kate', 'Lewis',''),7
('Ailisa', 'Gomez', 'ailisa@email.com'),8
('Gwendolyn', 'James', ''),9
('Simon', 'Collins', ''),10
('Taylor', 'Martin',''),11
('Andrew', 'Thompson', 'andrew123@email.com');
xxxxxxxxxx1
DROP TABLE IF EXISTS "users";2
CREATE TABLE "users" (3
"id" SERIAL,4
"name" VARCHAR(50) NOT NULL,5
"surname" VARCHAR(50) NOT NULL,6
"email" VARCHAR(100),7
"department_id" INTEGER,8
"salary" DECIMAL(15,2) NOT NULL,9
PRIMARY KEY ("iusers_without_emaild")10
);xxxxxxxxxx1
INSERT INTO "users"2
( "name", "surname", "email", "department_id", "salary")3
VALUES4
('John', 'Stewart', 'john@email.com', 1, '3512.00'),5
('Chris', 'Brown', 'chris@email.com', 2, '1344.00'),6
('Kate', 'Lewis', NULL, 3, '6574.00'),7
('Ailisa', 'Gomez', 'ailisa@email.com', 2, '6500.00'),8
('Gwendolyn', 'James', NULL, NULL, '4200.00'),9
('Simon', 'Collins', NULL, 4, '3320.00'),10
('Taylor', 'Martin', NULL, NULL, '1500.00'),11
('Andrew', 'Thompson', 'andrew@email.com', NULL, '2100.00');
xxxxxxxxxx1
xxxxxxxxxx1
