On pgAdmin 4, how to basically copy the content of one or two cells?

Question

I decided to go on pgAdmin 4 instead of the 3 (I'm on Windows 7). It seems that this software if somehow still in a alpha state...

I would like to only get the content of one cell. So I select this cell and tap Ctrl+C.

But it seems NOT to copy the content to the clipboard (the previous clipboard content stays when I paste...).

I notice that the copy button in the topbar stays disabled...

On the pgAdmin 4 GUI Tool page, it seems the only proposed way to copy is to click on this button :

Click the Copy icon to copy the currently selected row.

Do anybody has a better way to do this ?

Costea · Answer 1 · 2017-12-07T10:11:50.000

7

This is for pgAdmin 4 / Version 2.0

Hit F8 (download as CSV) , or click the rightmost button

After that, save the Data Output as a csv file (of your choice)

edited Dec 07 '17 at 10:11

answered Dec 07 '17 at 10:01

Costea

71
1
2

1

As of now, this button (or F8) saves the file as CSV but its content is XML... – karatedog Jun 25 '19 at 11:51

score 6 · Answer 2 · answered Dec 21 '16 at 10:14

6

OK I've found.

You have to double click on the cell, then a popup pops up, with the cell content selected, and then you can use ctrl+c...

answered Dec 21 '16 at 10:14

Louis V

301
1
2
7

score 2 · Answer 3 · answered Apr 16 '17 at 02:58

2

There is a green row with a floppy disk that saves the result of your query.

answered Apr 16 '17 at 02:58

user3550873

21
1

1

The OP wants to copy the content of one cell. – McNets Apr 16 '17 at 13:15
OP asked about pgadmin4, not 3. Version 4 has a button to download the results as CSV, but only after executing. – SPRBRN Aug 03 '19 at 15:05

score 1 · Answer 4 · edited Feb 03 '20 at 11:43

1

For integer or double columns, the 'pop-up' mentioned by @user3550873 doesn't appear so you cannot copy from there, but there is a workaround :

Drag and Drop works !

So, you can drag-and-drop the value you want to the query text field, then copy it anywhere from there.

edited Feb 03 '20 at 11:43

tinlyx

3,540
13
46
72

answered Feb 03 '20 at 11:03

Mathieu Galle

11
1

Siwei · Answer 5 · 2022-09-29T04:42:29.813

1

A solution with some limit:

click on the target cell
ctrl + c

It works when the window can show all the columns. If you scroll from left to right for the result(if the result has many columns), it doesn't work. Maybe it's a bug.

edited Sep 29 '22 at 04:42

answered Sep 29 '22 at 03:04

Siwei

111
5

score 0 · Answer 6 · answered Sep 03 '19 at 09:34

0

In PgAdmin 4 there is the configuration for show max characters per column. Go to file > options > query tool, update the "max. characters per column" as per your limit, I have set as 10000.

answered Sep 03 '19 at 09:34

Vinit Solanki

101
1

1

the problem is that I can see a lot of characters, much more than copied using the Ctrl+C key combination. I have to use the @user3550873 solution to get the whole cell saved from the query – oleksa Dec 13 '19 at 07:17

On pgAdmin 4, how to basically copy the content of one or two cells?

6 Answers6