I know that it could be done programatically, but is there any tool that I can use directly? For instance I could import shapefile to postgresql through postgis shapefile loader.
The shp2pgsql
tool is the only thing I'm aware of. Are you looking for some sort of UI for this functionality?