DataGrip can't export to SQL inserts
For a table called variants under postgresql. I right click on that table and select Dump Data to file then select SQL inserts. I get an error:
9:26 AM SELECT t.* FROM public.variants t
[42P01] ERROR: relation "public.variants" does not exist
Position: 17
This query works in the console but when I do the Dump data to file it fails.
Please sign in to leave a comment.
Tanks! Fixed. Should work in 2018.1 EAP
As a workaround for 2017.3 try to put the needed database in the connection URL.
I have exactly the same issue now in the version 2018.1.1 even though I have configured the right database and schema to connect. Even more I had an script saved in the console, a simple select to a table, that was working two versions before.
@Jv
Could you describe your problem in detail?