CREATE TABLE t1(id SERIAL PRIMARY KEY,
			 fio VARCHAR,
			 f1 DOUBLE PRECISION);

CREATE TABLE t2(id SERIAL PRIMARY KEY,
			 fio VARCHAR,
			 f2 DOUBLE PRECISION);
			

-- Ввод данных

INSERT INTO t1(id,fio,f1) VALUES (1,'Petrov',100);
INSERT INTO t1(id,fio,f1) VALUES (2,'Ivanov',30);
INSERT INTO t1(id,fio,f1) VALUES (3,'Smirnov',55);

INSERT INTO t2(id,fio,f2) VALUES (4,'Kiselev',15);
INSERT INTO t2(id,fio,f2) VALUES (5,'Loginov',70);

SELECT * FROM t1 FULL OUTER JOIN t2 ON t1.id=t2.id;

 id |   fio   | f1  | id |   fio   | f2
----+---------+-----+----+---------+----
  1 | Petrov  | 100 |    |         |
  2 | Ivanov  |  30 |    |         |
  3 | Smirnov |  55 |    |         |
    |         |     |  5 | Loginov | 70
    |         |     |  4 | Smirnov | 15

SELECT * FROM t1 FULL OUTER JOIN t2 USING(id,fio);