Joshua D. Boyd

Search
Skip to content
  • About
  • All Testimonials
  • All Projects
Other

postgres dump query to file

January 27, 2017 jdboyd

\copy (select fields from table where something=otherthing) to '/tmp/test.csv' with HEADER CSV;

Share this:

  • Share
  • Click to share on Pocket (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to print (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Reddit (Opens in new window)

Related

Post navigation

Previous PostPrevious PostNext PostRecipes

Acurately predicted 20 out of the last 4 Zebra stampedes.

Me on other Sites

  • @jdboyd on Twitter
  • Boyd Recipes
  • jd-boyd on github
  • joshua-d-boyd on StackOverflow
  • Linkedin

Categories

  • Cooking
  • Emacs
  • Family
  • Other
  • Programming
  • Reviews
  • System Administration
Proudly powered by WordPress