PG Admin copy & paste to Excel
Published on 4/18/2015
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
Sample:
PG Admin:
Excel:
