Exporting a Postgres Database to an Excel Spreadsheet

Question

I have a PostgreSQL database at work that is a single table of data. The theme of the data is computers - things like physical location, MAC address, serial number, and computer name.

I need to get this data exported to an Excel spreadsheet. I have Perl with DBD::Pg loaded on a laptop, so a programmatic solution is possible if need be.

Should I process the whole thing line-by-line with a loop, or is there an easier way to get a CDL? Has anyone had any experience with doing this sort of thing successfully before?

Thanks so much.

dmirkitanov · Accepted Answer · 2011-07-07 17:30:51Z

4

If the solution doesn't have to be programmatic, this should help: archives.postgresql.org article

edited Jul 7, 2011 at 17:30

answered Jul 7, 2011 at 16:45

dmirkitanov

1,3961 gold badge12 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bruno · Accepted Answer · 2011-07-07 16:46:26Z

3

This is not really a programming answer, but this has already been programmed, if exporting to CSV is acceptable.

You can look into:

using COPY,
using the \o or \copy commands in psql (there's quite a lot of references if you google something like "psql export csv"),
if you have a tool like pgAdmin, you can export the results of a query in File->Export...

answered Jul 7, 2011 at 16:46

Bruno

123k33 gold badges278 silver badges389 bronze badges

Comments

Dan Winer · Accepted Answer · 2011-07-08 11:12:14Z

1

If you have access to a Mac then Navicat for PostgreSQL Lite will allow you to do exactly this and is available for free in the Mac App Store. It is really simple to use and has a great interface to setup the connection to the database and to browse to the information you need.

answered Jul 8, 2011 at 11:12

Dan Winer

692 silver badges8 bronze badges

Collectives™ on Stack Overflow

Exporting a Postgres Database to an Excel Spreadsheet

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related