The correct Answer by richyen explains how the host-based access settings of pg_hba.conf file are not editable by pgAdmin 4. So we must use a text-editor to edit the pg_hba.conf file directly.
Example on macOS
Here is an example of using an editor to do so, the command-line tool nano, on macOS (and possibly on BSD).
The Postgres database system is ...
there are command line tools that do field type inferencing.
One is xsv https://github.com/BurntSushi/xsv/
Running this command on this (https://gist.githubusercontent.com/aborruso/3b1af402f0d2ed49465f218d19be81d9/raw/c0e95b320924e9e49902633d16e7ab253046ca16/input.csv)
xsv stats input.csv --everything | xsv table
field type sum ...
Where does the csv originate from? - I would guess some other database - can't you use the create table statements used for the other database?
That aside, though a second data-set would be helpful -
IDI is obviously an integer
S02Q01_Gender .. depending on your scenario most likely an enum type
the other columns look like string-data so tinytext seems ...