Skip to content

Instantly share code, notes, and snippets.

@giacecco
Last active October 27, 2015 14:00
Show Gist options
  • Save giacecco/237d1a28cfe13050cd28 to your computer and use it in GitHub Desktop.
Save giacecco/237d1a28cfe13050cd28 to your computer and use it in GitHub Desktop.
.../database$ psql -d olaf_yr2_paper -f create_crowdflower_init_csv.sql
psql:create_crowdflower_init_csv.sql:5: \copy: arguments required
psql:create_crowdflower_init_csv.sql:14: ERROR: syntax error at or near "TO"
LINE 5: TO '/Users/giacecco/Documents/PhD/GitHub projects/OLAF-yr2...
^
.../database$
\COPY
(SELECT oson_id, type
FROM
lab_summary AS a,
(VALUES ('lowest'), ('highest')) AS b(type))
TO 'crowdflower_init.csv'
WITH (
FORMAT csv,
HEADER true
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment