Skip to content

Instantly share code, notes, and snippets.

@jc00ke

jc00ke/copy.sql

Created January 8, 2014 19:07
Show Gist options
  • Save jc00ke/8322466 to your computer and use it in GitHub Desktop.
Save jc00ke/8322466 to your computer and use it in GitHub Desktop.
Download ZIP
psql \copy csv
Raw
copy.sql
\copy (
select
name,
unit_price
from
widgets
) to 'widgets.csv' with (FORMAT CSV, force_quote *, header);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment