Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cAPKr-0005Tv-F6 for pgsql-docs@arkaria.postgresql.org; Fri, 25 Nov 2016 22:51:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cAPKq-00048C-Lj for pgsql-docs@arkaria.postgresql.org; Fri, 25 Nov 2016 22:51:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cAPKp-00045o-CD for pgsql-docs@postgresql.org; Fri, 25 Nov 2016 22:51:11 +0000 Received: from smtprelay0092.b.hostedemail.com ([64.98.42.92] helo=smtprelay.b.hostedemail.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cAPKl-00035P-G5 for pgsql-docs@postgresql.org; Fri, 25 Nov 2016 22:51:10 +0000 Received: from filter.hostedemail.com (10.5.19.248.rfc1918.com [10.5.19.248]) by smtprelay04.b.hostedemail.com (Postfix) with ESMTP id 58AED7B616; Fri, 25 Nov 2016 22:51:05 +0000 (UTC) X-Session-Marker: 616C76686572726540616C76682E6E6F2D69702E6F7267 X-Spam-Summary: 50,0,0,,d41d8cd98f00b204,alvherre@alvh.no-ip.org,:::,RULES_HIT:41:355:379:599:800:967:973:982:988:989:1260:1277:1311:1312:1313:1314:1345:1359:1437:1515:1516:1518:1519:1534:1540:1593:1594:1595:1596:1711:1730:1747:1777:1792:2393:2525:2561:2564:2682:2685:2828:2859:2933:2937:2939:2942:2945:2947:2951:2954:3022:3138:3139:3140:3141:3142:3352:3865:3866:3868:3934:3936:3938:3941:3944:3947:3950:3953:3956:3959:4605:5007:6117:6119:6261:7514:7809:7903:9025:9121:10004:10400:10848:11232:11658:11914:12043:12324:13069:13161:13229:13311:13357:13439:13891:13894:13895:14181:14721:14764:21080:30054:30062:30079,0,RBL:none,CacheIP:none,Bayesian:0.5,0.5,0.5,Netcheck:none,DomainCache:0,MSF:not bulk,SPF:fn,MSBL:0,DNSBL:none,Custom_rules:0:0:0,LFtime:2,LUA_SUMMARY:none X-HE-Tag: legs73_266ba7ad04b44 X-Filterd-Recvd-Size: 1648 Received: from alvin.alvh.no-ip.org (unknown [216.155.90.98]) (Authenticated sender: alvherre@alvh.no-ip.org) by omf05.b.hostedemail.com (Postfix) with ESMTPA; Fri, 25 Nov 2016 22:51:03 +0000 (UTC) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id E5E7CA81; Fri, 25 Nov 2016 19:51:00 -0300 (CLST) Date: Fri, 25 Nov 2016 19:51:00 -0300 From: Alvaro Herrera To: hvrauhal@gmail.com Cc: pgsql-docs@postgresql.org Subject: Re: The options to COPY statement can not be separated with a comma Message-ID: <20161125225100.xoa25ehbranosunk@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20161125112813.6539.29538@wrigleys.postgresql.org> User-Agent: NeoMutt/20161104 (1.7.1) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org hvrauhal@gmail.com wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/9.5/static/sql-copy.html > Description: > > The documentation describes: > [ [ WITH ] ( option [, ...] ) ] > > But actually the options are only separated by spaces, for example > `with CSV HEADER NULL '';` The documentation describes new-style options, which are enclosed by parens and separated by commas. Old-style (pre-9.0) did not have the comma separators nor parens; those are still supported but should not be used by new applications. See "Compatibility" at the bottom of the page. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs