Questions tagged [datagrip]

DataGrip is a cross-platform IDE for databases & SQL by JetBrains

Filter by
Sorted by
Tagged with
0
votes
1answer
20 views

postgres function definition not saving top whitespace

For reference I am running postgres 9.6 . I'd like to write functions inside of postgres where the top of the function saves. create or replace function apqp.apqp_list_gentex_tool_report_getlist(...
1
vote
2answers
37 views

How to set “PRAGMA foreign_keys = ON” each time I'm connecting to sqlite db via Datagrip

In my pet project I'm working with small sqlite db and I've just came to realization that, in order to ON DELETE CASCADE actually do the thing, I need to set PRAGMA foreign_keys = ON each time I'm ...
0
votes
1answer
93 views

Moving a large table from Localhost to remote server

Postgres 11, Windows 10, pgAdmin 4 I have a large post-gis enabled table (29million rows, 20GB + a 5GB spatial index) stored on my local machine (localhost). I want to move this table to an AWS ...
0
votes
1answer
319 views

Datagrip EXPLAIN ANALYZE Gui?

In Datagrip (using 2018.2.4), you can right-click on a query and choose 'Explain' which gives nicely formatted output. Is there anyway to get this nicely formatted output using instead 'Explain ...
0
votes
1answer
167 views

PostgreSQL Select statement produces errors in datagrip but not pgAdmin4

I can run the following script without errors in pgadmin4 SELECT * from tbl I have tried the following in datagrip SELECT * from tbl and SELECT * from public.tbl Neither of the above scripts ...
0
votes
0answers
45 views

DataGrip commands with non-US keyboard

DataGrip editor has command ⌘-/ to "Comment with line comment", in SQL that means adding -- to beginning of line. On my MacBook Pro with Finnish keyboard, / is located in shift-7. When I press ⌘-...
-1
votes
1answer
301 views

OS X 10.12 // Setting up mySQL server // JetBrains DataGrip

I am a novice beginning to learn SQL. I have gone through tutorials on how to set up mySQL server, and am trying to use DataGrip as well. When I try to connect DataGrip to the mySQL server, it says my ...
1
vote
1answer
905 views

DataGrip shows a time substantially slower than EXPLAIN ANALYZE

I searched alot for the answer to my question. I have a table with 134 rows and 4 rows. My EXPLAIN ANALYZE says the execution time was: 0.038ms. But the actual execution time (using DataGrip) was: ...
5
votes
1answer
2k views

Null instead '0000-00-00 00:00:00' in mysql 5.7

Before: mysql 5.6. One of the columns in the table is created as follows: `f_stamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' When i view this field in mysql client or using DataGrip, this ...