Main Menu

SSTS Blog

Some news and tidbits that we share

How to extract Postgres tables to csv files

by SSTS on Jun 18 in Blog 0 Comments

The Postgres COPY command can be run within psql to extract csv files for exchange to an external system. You supply

a file location, delimiter, and format.

Here's an example:

COPY products_273 TO '/tmp/products_199.csv' DELIMITER ',' CSV HEADER;

Tags: Untagged

Author

About the author

SSTS

Server Side Technology Solutions is a consulting firm that specializes in database design, development and support.

http://www.serverside-ts.com

Comments

Please login first in order for you to submit comments

Lower Your Costs

Lower the costs of your DBA while ensuring that you have the quality that your company needs to remain successful and optimized!

24 x 7 Monitoring

For things that are essential to your success, do not let potential hazards stand in the way. With our 24x7 Monitoring Alert System, we can make sure your systems are always running as efficiently as they should be, even if you're sleeping.

Get A Solution

We have extensive experience in the field which allows us to approach every situation head on and find the best solution quickly. Our solutions are custom tailored to your needs. We will work with you in coming up with a services agreement that fits your needs.

Solutions...