[GENERAL] copy syntax
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) achamb...@mcna.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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] copy syntax
On Wed, 2012-04-04 at 16:01 -0400, Andy Chambers wrote: > 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? > Yes, you need parentheses, like this: copy ar_data from '/tmp/ar-data.csv' with (header true); -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] copy syntax
Am 04.04.2012 22:01, schrieb Andy Chambers: 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? copy ar_data from $$/tmp/ar-data.csv$$ csv header delimiter ';' ; ... providet it's not a REAL csv as in "comma separated ..." ... $$ works better as ' at leas when you need to have backslashes in the path. ... and you'll need to mind the encoding of the CSV if you use some international signs -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general