copy syntax

From: Andy Chambers <achambers(at)mcna(dot)net>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: copy syntax
Date: 2012-04-04 20:01:19
Message-ID: CAAfW55oXomnjn8VrM_E0GQw+uGPDg2EoJSZkNJK1A9CxX2hhQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

dcm_eob=> copy ar_data from '/tmp/ar-data.csv' with header true;
ERROR: syntax error at or near "true"
LINE 1: copy ar_data from '/tmp/ar-data.csv' with header true;

I can't figure out what's wrong with the syntax above. Is something missing?

--
Andy Chambers
Software Engineer
(e) achambers(at)mcna(dot)net
(t) 954-682-0573

CONFIDENTIALITY NOTICE: This electronic mail may contain information
that is privileged, confidential, and/or otherwise protected from
disclosure to anyone other than its intended recipient(s). Any
dissemination or use of this electronic mail or its contents by
persons other than the intended recipient(s) is strictly prohibited.
If you have received this communication in error, please notify the
sender immediately by reply e-mail so that we may correct our internal
records. Please then delete the original message. Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2012-04-04 20:04:26 Re: copy syntax
Previous Message PM Support 2012-04-04 19:10:28 Function with variables/insert/for loop problems