Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE contact (id serial, name text, gender int, city text, birthdate date);
CREATE TABLE education (user_id int, place text, degree text, endyear date);
CREATE TABLE status (user_id int, status text);

CREATE TABLE

CREATE TABLE

CREATE TABLE

DO $$
DECLARE returned_id int;
BEGIN
  INSERT INTO contact 
   (name, gender, city, birthdate) VALUES 
   ('Name', 1, 'City', '2000-02-03')
  RETURNING id INTO returned_id;
  
  INSERT INTO education 
   (user_id, place, degree, endyear) VALUES 
   (returned_id, 'some_place', 'some_state', '1990-01-01');
	
  INSERT INTO status 
   (user_id, status) VALUES 
   (returned_id, 'val');	
END;
$$;

DO

SELECT * FROM education; 

user_id
place
degree
endyear

1
some_place
some_state
1990-01-01

SELECT 1

SELECT * FROM status; 

user_id
status

1
val

SELECT 1