datagripintellij-datagrip

How to open/view/import .dbf file in jetbrains datagrip?

How do I work with .dbf files in Jetbrains DataGrip ? I am on macos and need to work with .dbf file. I managed to open dbf file in Shapefile explorer software. But I would like to use cool features DataGrip offering. Is it possible?

Solution

  • done with shp2pgsql

    for example:

    shp2pgsql -s 4326 -g geom_4326 "file_name" schema.table | psql -h localhost -p 5432 -d database -U user