Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
doc: mention that COPY MATCH requires columns _in_ _order_
authorBruce Momjian <bruce@momjian.us>
Wed, 10 Aug 2022 00:37:53 +0000 (20:37 -0400)
committerBruce Momjian <bruce@momjian.us>
Wed, 10 Aug 2022 00:37:53 +0000 (20:37 -0400)
Question asked at SCaLE conference.

Reported-by: doc suggestion by Stephen Frost
Backpatch-through: 15

doc/src/sgml/ref/copy.sgml

index 8aae711b3b9ef407ed7ace7b17a6dff1fd34e8e1..63afa0d97e08ae990a27b8d32c65529b364830f0 100644 (file)
@@ -280,7 +280,7 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable
       option is set to <literal>true</literal> (or equivalent Boolean value).
       If this option is set to <literal>MATCH</literal>, the number and names
       of the columns in the header line must match the actual column names of
-      the table, otherwise an error is raised.
+      the table, in order;  otherwise an error is raised.
       This option is not allowed when using <literal>binary</literal> format.
       The <literal>MATCH</literal> option is only valid for <command>COPY
       FROM</command> commands.