pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Assaf Gordon <assafgordon@gmail.com>
Subject: [PATCH] Add new-vs-old COPY syntax example in documentation
Date: Thu, 29 Sep 2016 11:06:35 -0400

---
 doc/src/sgml/ref/copy.sgml | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)


inline patch 1: doc/src/sgml/ref/copy.sgml (+25/-0 lines) download inline-1.patchdiff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml
index 07e2f45..531009b 100644
--- a/doc/src/sgml/ref/copy.sgml
+++ b/doc/src/sgml/ref/copy.sgml
@@ -86,6 +86,31 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable
  </refsect1>
 
  <refsect1>
+  <title>New versus old syntax</title>
+  <para>
+   Starting with <productname>PostgreSQL</> version 9.0, the
+   <command>COPY</command> commands supports new syntax with parenthesis
+   and commas. The old syntax is still supported, see details
+   at the bottom of this page.
+  </para>
+
+  <para>
+   New syntax:
+<programlisting>
+COPY country TO STDOUT (FORMAT CSV, NULL 'NA', HEADER ON);
+</programlisting>
+  </para>
+
+  <para>
+   Old syntax:
+<programlisting>
+COPY country TO STDOUT NULL 'NA' CSV HEADER;
+</programlisting>
+  </para>
+
+ </refsect1>
+
+ <refsect1>
   <title>Parameters</title>
 
   <variablelist>
-- 
2.8.2



--------------AFE6B15702E45E67FE86E19E
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

--------------AFE6B15702E45E67FE86E19E--




Message-ID: <no-message-id-9287@localhost>
Permalink:  ../no-message-id-9287@localhost/
Also on:    postgresql.org/message-id/no-message-id-9287@localhost

 ·  · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: assafgordon@gmail.com
  Subject: Re: [PATCH] Add new-vs-old COPY syntax example in documentation
  In-Reply-To: <no-message-id-9287@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox