• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1012
  • Last Modified:

How do I export data from PostgreSQL?

How can I export a table from postgreSQL to import into DB2?  DB2 can import .csv, .del, .ixf files.  If I can even get a deliminated file, I can import it into Excel to create a .csv.

Please Help.

Thank you,
Mike
0
HeavyRocker
Asked:
HeavyRocker
1 Solution
 
rjkimbleCommented:
Check out the COPY SQL command. Connect via psql and run:

\h COPY

You want the "TO" version.

Alternatively, you can connect to PostgreSQL with Excel and copy the data that way. I do that with OpenOffice.org all the time. Access would work, too.
0
 
HeavyRockerAuthor Commented:
Thank you for your help....worked great!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now