Converting xls into csv in QGIS with correct column definitions and exporting the data into postgis

I would avoid depending on QGIS to load CSV data, especially given the amount of non-spatial data that CSV's are likely to have in which data types can be mis-read.

Instead, I recommend using CSVKit to not only define the columns in the tables that will result from your CSV import, but then use PostGIS functions to build the spatial data, etc.

CSVKit can read a CSV and create a column definition:

csvsql -i postgresql crime.csv

Yields this result:

CREATE TABLE crime (
    "INCIDENT_ID" FLOAT NOT NULL,
    "OFFENSE_ID" BIGINT NOT NULL,
    "OFFENSE_CODE" VARCHAR(4) NOT NULL,
    "OFFENSE_CODE_EXTENSION" INTEGER NOT NULL,
    "OFFENSE_TYPE_ID" VARCHAR(30) NOT NULL,
    "OFFENSE_CATEGORY_ID" VARCHAR(28) NOT NULL,
    "FIRST_OCCURRENCE_DATE" TIMESTAMP WITHOUT TIME ZONE NOT NULL,
    "LAST_OCCURRENCE_DATE" TIMESTAMP WITHOUT TIME ZONE,
    "REPORTED_DATE" TIMESTAMP WITHOUT TIME ZONE NOT NULL,
    "INCIDENT_ADDRESS" VARCHAR(97),
    "GEO_X" FLOAT NOT NULL,
    "GEO_Y" FLOAT NOT NULL,
    "GEO_LON" FLOAT,
    "GEO_LAT" FLOAT,
    "DISTRICT_ID" INTEGER,
    "PRECINCT_ID" INTEGER,
    "NEIGHBORHOOD_ID" VARCHAR(26),
    "IS_CRIME" INTEGER NOT NULL,
    "IS_TRAFFIC" INTEGER NOT NULL
);

But even better, you accomplish the above and load the CSV in one command:

csvsql --db postgresql://username:password@servername/databasename --table denver_crime --insert crime.csv

Here is a tutorial I created when I need to do just this:

https://github.com/dpsspatial/Installation-Instructions/blob/master/csvkit.md

I also recommend using DBeaver instead of PGAdmin for any of this work, as it is a much more user-friendly / analyst-designed GUI to your database than the DBA-designed PGAdmin (I will have to update the tutorial screenshots - PGAdmin 3 was OK, PGAdmin 4 is way too heavy, and luckily DBeaver came along for us at the right time).