How to export query results directly to a local CSV file from RubyMine

Question

I am using RubyMine 6.3.3 Database Console window to run queries and export them to CSV

This involves 3 steps

Step 1. Run the query, wait quite some time to get results in a Visual way

Run the query to get results in a Visual way

Step 2. Click on the "File Icon" and select "Save All To File"

Click on the "File Icon" and select "Save All To File

Step 3: Wait again the same time of the step 1 to export it to CSV

enter image description here

I have checked RubyMine forums, the settings, whithout any success.

The answer to that question mentions this command

Copy (Select * From foo) To '/tmp/test.csv' With CSV;

but by using that approach the file is save on the server which I dont have direct access to.

Is there a way to run the query and get the results directly into a local CSV file, without getting the visual results

Can you connect to the database from [psql](http://www.postgresql.org/docs/current/static/app-psql.html)? — Clodoaldo Neto, Jul 10 '14 at 15:09
@ClodoaldoNeto I actually made a dumb mistake when configuring pgadmin and now I can connnect, but still this feature is planed. see my own answer — Mauricio Gracia Gutierrez, Jul 11 '14 at 14:38

score 3 · Answer 1 · answered Mar 15 '19 at 11:28

3

Yes, there is a way to do what you ask:

answered Mar 15 '19 at 11:28

moscas

score 1 · Answer 2 · answered Jan 23 '16 at 09:02

1

This feature is working in RubyMine 8

On the right side of your query result you can select the export type.

Refresh/reload your query

Select the lines you want to export, e.g. cmd + a to select all

copy the values with cmd + c

open a new textfile and paste the data with cmd + v

answered Jan 23 '16 at 09:02

lumos0815

Or, if you want to export the whole table/result at once, there is a button "Dump data to file" – moscas Mar 15 '19 at 11:27

score 0 · Accepted Answer · answered Jul 11 '14 at 14:29

This feature is not yet implemented and is already and feature that has been requested to JetBrains and is reported in this links

So people interested in tracking this and update this answer please do.

score 0 · Answer 4 · answered Jul 11 '14 at 14:44

0

If you can connect with psql use the \copy command to save the file at the client.

answered Jul 11 '14 at 14:44

Clodoaldo Neto

@clodoado thanks for the answer, this helps me solve the original problem, but this answer is not related to the original question – Mauricio Gracia Gutierrez Jul 11 '14 at 17:06

4 Answers4