Saturday, April 18, 2015

PG Admin copy & paste to Excel

PG Admin copy & paste to Excel doesn't work well by default, at least on Windows.

Here's how to fix it:

In PG Admin, on the main menu, go to

File > Options... > Query tool > Results grid , and set:

Result copy field separator to Tab

and (optionally) check Copy column names.

In Query window, in Output pane, CTRL+A to select all and CTRL+C to copy


PG Admin:


No comments: