MyTable has fields like slno,longitude,latitude
We have to combine longitude,latitude and make another field say 'geom' of type 'public.geometry'
in order to do that first create field 'geom' and execute the following statement.
UPDATE MyTable
SET geom = (SELECT ST_GeomFromText('POINT('||longitude||' '||latitude||')'))
Now that you have PSQL table Open it in QGIS software as vector layerand save as .shape file.
A deep creative Elucidations for a problem comes from the depth understanding of the problem. Back bench signifies emancipated minds, only those minds siting at the back bench and meditates deep in to the understanding of the problems will see what has to be seen
