2

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?

IamMashed
  • 1,811
  • 2
  • 21
  • 32

3 Answers3

4

I use dbf-to-sqlite Python package - pretty straightforward way to discover DBF structure and data inside. It creates SQLite database which supported by DataGrip out of the box.

pip install dbf-to-sqlite
dbf-to-sqlite PIndx01.dbf post_index.sqlite
Mikhail Aksenov
  • 944
  • 9
  • 23
2

There is no way to do that and even there is no ticket in the tracker: https://youtrack.jetbrains.com/issues/DBE

moscas
  • 9,064
  • 36
  • 42
0

done with shp2pgsql

for example:

shp2pgsql -s 4326 -g geom_4326 "file_name" schema.table | psql -h localhost -p 5432 -d database -U user
IamMashed
  • 1,811
  • 2
  • 21
  • 32