$ sudo -u postgres psql corspat < restore.sql
[…]

$ sudo -u postgres psql corspat
psql (15.5)
Type "help" for help.

corspat=# \dt
           List of relations
 Schema |    Name     | Type  |  Owner
--------+-------------+-------+---------
 public | alerts      | table | corspat
 public | path        | table | corspat
 public | timetracker | table | corspat
 public | users       | table | corspat
(4 rows)

corspat=# SELECT count(*) from alerts;
 count
-------
     2
(1 row)

corspat=# SELECT count(*) from path;
 count
-------
    58
(1 row)

corspat=# SELECT count(*) from timetracker;
 count
-------
   500
(1 row)

corspat=# SELECT count(*) from users;
 count
-------
    14
(1 row)