Загрузка данных


CREATE TABLE students (

    id SERIAL PRIMARY KEY,

    name VARCHAR(15) NOT NULL,

    age INT,

    grade FLOAT,

    phone VARCHAR(11)

);

INSERT INTO students (name, age, grade, phone)

VALUES

('Leha', 19, 4.5, '8984456123'),

('Dani', 27, 3.8, '89111111111'),

('Ivan', 14, 4.2, '89777777777'),

('Gleb', 22, 4.7, '89333333331'),

('Roma', 24, 3.9, '89993334455');

SELECT * FROM students;