From duhanic@gmail.com Mon Jun 1 08:15:47 2026 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIGZU-00053X-7T for pgsql-docs@arkaria.postgresql.org; Wed, 20 Mar 2013 10:48:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UIGZT-0005F5-Mm for pgsql-docs@arkaria.postgresql.org; Wed, 20 Mar 2013 10:48:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIGZS-0005Ez-Q4 for pgsql-docs@postgresql.org; Wed, 20 Mar 2013 10:48:38 +0000 Received: from mail-vc0-f178.google.com ([209.85.220.178]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIGZN-0001ra-Rx for pgsql-docs@postgresql.org; Wed, 20 Mar 2013 10:48:37 +0000 Received: by mail-vc0-f178.google.com with SMTP id hz11so1174090vcb.37 for ; Wed, 20 Mar 2013 03:48:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:date:message-id:subject:from:to :content-type; bh=tRptY2syqgx0QyK0cVSxInkWfq9fsZx/w7PusIFt4YI=; b=DFffDSJq1U2t3x25ZWrih6T9SjIodIQQRoMGosDOJhT+RA8cu9FtiLH6knws+TAipU qMPjXnEhF7xpuX0VUKhgXTyt+Mw6oUKaEwYvF/tzwq0fejI2vLlJD6UHOpjPSIrRz5aq IHNhUga1QpTJvrYpBHXAYPon+APqRuN/EMDpB5+KZJJU3Zw1myo1T/rFnVzFEvqdPnxy vQooIRCeBQsc0S5T2YkWkZtDaMxVgoeR18wiByASUgvYCV/Dcv5xETqlBUYmngMJ2FtF t3LLxoHkrbjxnpVddhnGng1XvDBCD43LMSc6z/vY63q6VlbrzK1BDob0av80dRwDdD+b 0+gg== MIME-Version: 1.0 X-Received: by 10.58.173.131 with SMTP id bk3mr7035403vec.48.1363776511922; Wed, 20 Mar 2013 03:48:31 -0700 (PDT) Received: by 10.52.230.10 with HTTP; Wed, 20 Mar 2013 03:48:31 -0700 (PDT) Date: Wed, 20 Mar 2013 11:48:31 +0100 Message-ID: Subject: Underscorces in copy-documentation (9.0 and higher) From: Mario Duhanic To: pgsql-docs@postgresql.org Content-Type: multipart/alternative; boundary=047d7b677b3e8bdae304d858f6f7 X-Pg-Spam-Score: -2.7 (--) 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 --047d7b677b3e8bdae304d858f6f7 Content-Type: text/plain; charset=ISO-8859-1 Hi, - http://www.postgresql.org/docs/9.2/static/sql-copy.html, - http://www.postgresql.org/docs/9.1/static/sql-copy.html and - http://www.postgresql.org/docs/9.0/static/sql-copy.html have underscores ("_") where there should be none, e.g. in "FORCE_QUOTES". Best regards, --047d7b677b3e8bdae304d858f6f7 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable --047d7b677b3e8bdae304d858f6f7-- From tgl@sss.pgh.pa.us Mon Jun 1 08:15:47 2026 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIJeN-0002Iq-8A for pgsql-docs@arkaria.postgresql.org; Wed, 20 Mar 2013 14:05:55 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UIJeM-0006sG-Ls for pgsql-docs@arkaria.postgresql.org; Wed, 20 Mar 2013 14:05:54 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIJeL-0006ry-QP for pgsql-docs@postgresql.org; Wed, 20 Mar 2013 14:05:53 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIJeJ-000648-6A for pgsql-docs@postgresql.org; Wed, 20 Mar 2013 14:05:53 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id r2KE5nC1001554; Wed, 20 Mar 2013 10:05:49 -0400 (EDT) From: Tom Lane To: Mario Duhanic cc: pgsql-docs@postgresql.org Subject: Re: Underscorces in copy-documentation (9.0 and higher) In-reply-to: References: Comments: In-reply-to Mario Duhanic message dated "Wed, 20 Mar 2013 11:48:31 +0100" Date: Wed, 20 Mar 2013 10:05:49 -0400 Message-ID: <1553.1363788349@sss.pgh.pa.us> X-Pg-Spam-Score: -4.4 (----) 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 Mario Duhanic writes: > Hi, > - http://www.postgresql.org/docs/9.2/static/sql-copy.html, > - http://www.postgresql.org/docs/9.1/static/sql-copy.html and > - http://www.postgresql.org/docs/9.0/static/sql-copy.html > have underscores ("_") where there should be none, > e.g. in "FORCE_QUOTES". Huh? The references to FORCE_QUOTE look correct to me. The syntax doesn't support multi-word option names, so it has to be like that (or else run the words together, which doesn't sound like an improvement). regards, tom lane -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs From barwick@gmail.com Mon Jun 1 08:15:48 2026 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIKKR-0005zs-RF for pgsql-docs@arkaria.postgresql.org; Wed, 20 Mar 2013 14:49:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UIKKQ-0003V9-LY for pgsql-docs@arkaria.postgresql.org; Wed, 20 Mar 2013 14:49:22 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIKKI-0003Nw-Ma for pgsql-docs@postgresql.org; Wed, 20 Mar 2013 14:49:14 +0000 Received: from mail-bk0-x22d.google.com ([2a00:1450:4008:c01::22d]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIKKF-0006rz-Q3 for pgsql-docs@postgresql.org; Wed, 20 Mar 2013 14:49:14 +0000 Received: by mail-bk0-f45.google.com with SMTP id i18so919137bkv.18 for ; Wed, 20 Mar 2013 07:49:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:cc:content-type; bh=v8o0zPiCddKRSl4dygttMrsH974ly2hhEoQZn+HGbEE=; b=Z7Vu/GbKgSS5XJDqkA2B8lYnVBd9ruSH7159U1PquM+kF+w/NxYp320a5pS5Q87ITx 0O5/DuuEWyD3U4eFc5cE+JcFqOiFg10YKq6opveSnGrqqvopuFMHZP2qol1Ft7FBEwDq nnBOZnZFDAdq+x9aeHR0H7AL7F+X+h/LWwHwv0I14MI88ebfYnypLr6mGaBdoo5HnA0C lc+WCizcthn39C1mgs4xcwT2YnpwF9EgC7kBymh3VaWOOovIhh1p/goEP7ISky5mdEuJ VCqEdlM/wcam6CGYeZ6pjkd9RudjCXhG/2cnU1ya05lrgk7+KQzvfCv6/qRgDdU9QZg+ H1VA== MIME-Version: 1.0 X-Received: by 10.112.99.5 with SMTP id em5mr9755763lbb.1.1363790950325; Wed, 20 Mar 2013 07:49:10 -0700 (PDT) Received: by 10.152.22.1 with HTTP; Wed, 20 Mar 2013 07:49:10 -0700 (PDT) In-Reply-To: <1553.1363788349@sss.pgh.pa.us> References: <1553.1363788349@sss.pgh.pa.us> Date: Wed, 20 Mar 2013 23:49:10 +0900 Message-ID: Subject: Re: Underscorces in copy-documentation (9.0 and higher) From: Ian Lawrence Barwick To: Tom Lane Cc: Mario Duhanic , pgsql-docs Content-Type: text/plain; charset=UTF-8 X-Pg-Spam-Score: -2.0 (--) 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 2013/3/20 Tom Lane : > Mario Duhanic writes: >> Hi, >> - http://www.postgresql.org/docs/9.2/static/sql-copy.html, >> - http://www.postgresql.org/docs/9.1/static/sql-copy.html and >> - http://www.postgresql.org/docs/9.0/static/sql-copy.html > >> have underscores ("_") where there should be none, >> e.g. in "FORCE_QUOTES". > > Huh? The references to FORCE_QUOTE look correct to me. The syntax > doesn't support multi-word option names, so it has to be like that > (or else run the words together, which doesn't sound like an > improvement). FWIW, multi-word option names are pre-9.0 syntax and still supported. This is documented, albeit you have to scroll to the bottom of the page: http://www.postgresql.org/docs/current/static/sql-copy.html#AEN66823 Regards Ian Barwick -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs From duhanic@gmail.com Mon Jun 1 08:15:48 2026 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIKLO-00067g-HR for pgsql-docs@arkaria.postgresql.org; Wed, 20 Mar 2013 14:50:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UIKLN-0004Mw-8N for pgsql-docs@arkaria.postgresql.org; Wed, 20 Mar 2013 14:50:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIKLG-0004HQ-HT for pgsql-docs@postgresql.org; Wed, 20 Mar 2013 14:50:14 +0000 Received: from mail-ve0-f174.google.com ([209.85.128.174]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIKL9-00066W-GQ for pgsql-docs@postgresql.org; Wed, 20 Mar 2013 14:50:14 +0000 Received: by mail-ve0-f174.google.com with SMTP id pb11so1440418veb.19 for ; Wed, 20 Mar 2013 07:50:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=5kFAiLOA4kIgPif1O/P0GOakcnTOI3QZVG1lwRd17B8=; b=ff0VLO6NYcT62JLdsZoJqb4HSssXlWnmU5ENjltxjTy8SEQoPJrbw0oJ8oIw2lJ1w9 IP2g5VLFGSgrYMxJOIvfM4L042IjzhUhKKw7eX18FIY4JNFDV64eMz3udl9skL6+4fZD 67ON1lLgiODi/WSVoAk2nRJoYpFKNtOr3CRaNrwRTJGLorAHZ4BFj/tpouETmY2ZQ6E+ OJdQqQz40suv7Ldftf9tixlmHdfjxYSSHt3ue4udXrJblTOlEFYClUJUf6SUNy2AeXZD Ms8dQ4JhqDJw8B4o4K0iRRw6ojv7blzKrtu3Z7aYoXJtwjQuK2tY2VK0ON+piVwpGPSv USNg== MIME-Version: 1.0 X-Received: by 10.52.37.81 with SMTP id w17mr6900755vdj.70.1363791005638; Wed, 20 Mar 2013 07:50:05 -0700 (PDT) Received: by 10.52.230.10 with HTTP; Wed, 20 Mar 2013 07:50:05 -0700 (PDT) In-Reply-To: References: <1553.1363788349@sss.pgh.pa.us> Date: Wed, 20 Mar 2013 15:50:05 +0100 Message-ID: Subject: Fwd: Underscorces in copy-documentation (9.0 and higher) From: Mario Duhanic To: pgsql-docs@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Pg-Spam-Score: -2.7 (--) 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 2013/3/20 Tom Lane : > Huh? The references to FORCE_QUOTE look correct to me. The syntax > doesn't support multi-word option names, so it has to be like that > (or else run the words together, which doesn't sound like an > improvement). Thanks, Tom, for your quick response. Maybe this is just a miscommunication, sorry for that then (i.e. I misunderstood the documentation here). (Stupid) example for the problem: "COPY (SELECT aggfnoid, aggtransfn from pg_aggregate) TO STDOUT WITH FORCE QUOTE * DELIMITER ',' CSV HEADER;" will run, a FORCE_QUOTE or FORCEQUOTE won't (e.g. on a "PostgreSQL 9.2.3 on i386-portbld-freebsd9.1, compiled by cc (GCC) 4.2.1 20070831 patched [FreeBSD]"). Best regards, Mario -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs From tgl@sss.pgh.pa.us Mon Jun 1 08:15:48 2026 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIKOD-0006L0-4M for pgsql-docs@arkaria.postgresql.org; Wed, 20 Mar 2013 14:53:17 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UIKOC-0005vo-Bo for pgsql-docs@arkaria.postgresql.org; Wed, 20 Mar 2013 14:53:16 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIKOB-0005vj-Qy for pgsql-docs@postgreSQL.org; Wed, 20 Mar 2013 14:53:15 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIKO7-0006x6-OV for pgsql-docs@postgreSQL.org; Wed, 20 Mar 2013 14:53:15 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id r2KErAa8002773; Wed, 20 Mar 2013 10:53:10 -0400 (EDT) From: Tom Lane To: Mario Duhanic cc: pgsql-docs@postgreSQL.org Subject: Re: Underscorces in copy-documentation (9.0 and higher) In-reply-to: References: <1553.1363788349@sss.pgh.pa.us> Comments: In-reply-to Mario Duhanic message dated "Wed, 20 Mar 2013 15:49:14 +0100" Date: Wed, 20 Mar 2013 10:53:10 -0400 Message-ID: <2772.1363791190@sss.pgh.pa.us> X-Pg-Spam-Score: -4.4 (----) 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 Mario Duhanic writes: > 2013/3/20 Tom Lane : >> Huh? The references to FORCE_QUOTE look correct to me. The syntax >> doesn't support multi-word option names, so it has to be like that >> (or else run the words together, which doesn't sound like an >> improvement). > Thanks, Tom, for your quick response. > Maybe this is just a miscommunication, sorry for that then (i.e. I > misunderstood the documentation here). > (Stupid) example for the problem: > "COPY (SELECT aggfnoid, aggtransfn from pg_aggregate) TO STDOUT WITH > FORCE QUOTE * DELIMITER ',' CSV HEADER;" > will run, a FORCE_QUOTE or FORCEQUOTE won't As Ian notes, that's the old syntax with a hard-wired option set. The lack of parentheses after WITH is the difference. regards, tom lane -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs From duhanic@gmail.com Mon Jun 1 08:15:48 2026 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIKVu-0006yW-Ao for pgsql-docs@arkaria.postgresql.org; Wed, 20 Mar 2013 15:01:14 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UIKVt-0006In-Id for pgsql-docs@arkaria.postgresql.org; Wed, 20 Mar 2013 15:01:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIKVt-0006Ii-0P for pgsql-docs@postgresql.org; Wed, 20 Mar 2013 15:01:13 +0000 Received: from mail-ve0-f182.google.com ([209.85.128.182]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIKVl-0006IC-NT for pgsql-docs@postgresql.org; Wed, 20 Mar 2013 15:01:12 +0000 Received: by mail-ve0-f182.google.com with SMTP id ox1so1487183veb.13 for ; Wed, 20 Mar 2013 08:01:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=ghoUPhP934GZKtGS1teL7iHra4sWrG6pFD69HZhNFuQ=; b=Y9Abhvw6HrHVkA0NhlQBVbiLg76UTVdiOEY7qKvuIZhp0mp/QxAiXzwPUlca+MT8gI qc95JahlQEs31EuoslLtFxvWKkD3K0tlJchZOtx/7rsiCMhT2LUkr5g3E80ZdNdPeVys KjWpifRrIFkYDmWnhywZcIRnzNoS1ULhKE/Qsam8ikdRwqbXuk68MBUi+zbDQHCA5sdK HudOp4HtiNoT4oXkU/98s1hBvQVll1RumguYhsAbo6UgxE5EbYCbJ/lT/+zDuTJVRRP4 vYJj/62Cybxc9x4v6nM2bclgYJ7ICcmzB1m8uu4hmXEZPfgLJUEry/tAhD4LdymR8n4T xIMQ== MIME-Version: 1.0 X-Received: by 10.58.96.40 with SMTP id dp8mr8318574veb.41.1363791664467; Wed, 20 Mar 2013 08:01:04 -0700 (PDT) Received: by 10.52.230.10 with HTTP; Wed, 20 Mar 2013 08:01:04 -0700 (PDT) In-Reply-To: <2772.1363791190@sss.pgh.pa.us> References: <1553.1363788349@sss.pgh.pa.us> <2772.1363791190@sss.pgh.pa.us> Date: Wed, 20 Mar 2013 16:01:04 +0100 Message-ID: Subject: Re: Underscorces in copy-documentation (9.0 and higher) From: Mario Duhanic To: pgsql-docs@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Pg-Spam-Score: -2.7 (--) 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 2013/3/20 Tom Lane > As Ian notes, that's the old syntax with a hard-wired option set. > The lack of parentheses after WITH is the difference. Aarfh, thanks, guys! -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs