From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Andrei M. Eichler" <andrei.eichler@unicheck.com.br>
cc: Kevin Grittner <kgrittn@gmail.com>,
        "pgsql-docs@postgresql.org" <pgsql-docs@postgresql.org>
Subject: Re: COPY options
In-reply-to: 
 <CABS=F1+hjzqLgkx23p6RqPkyim_c2GOdMdsBZgGj27qAwwEyxw@mail.gmail.com>
References: 
 <CABS=F1+aHKpE9Z2CwnffwCOxRKn9pFuYBsoAkHCL82YLm2q3eg@mail.gmail.com>
 <CACjxUsM_4O40y_bMjh3UAMmY1q3dTqecJzqRBJFzp-wkZcYCGg@mail.gmail.com>
 <CABS=F1+hjzqLgkx23p6RqPkyim_c2GOdMdsBZgGj27qAwwEyxw@mail.gmail.com>
Comments: In-reply-to "Andrei M. Eichler" <andrei.eichler@unicheck.com.br>
	message dated "Fri, 29 Apr 2016 12:31:37 -0300"
Date: Fri, 29 Apr 2016 11:50:38 -0400
Message-ID: <16986.1461945038@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

"Andrei M. Eichler" <andrei.eichler@unicheck.com.br> writes:
> Following the documentation, I wrote this COPY FROM command:

> COPY test_copy FROM '/mnt/disk1/files/test_file.csv' with csv header
> delimiter ';' force_null date_column, date_column2, date_column3,
> date_column4, date_column5 encoding 'latin1';

Which part of the documentation, exactly, inspired you to write that?
Certainly not the main syntax summary for COPY, which would tell you
to write something like
	with (format csv, header, ...);

What you've got there is some variant of the pre-9.0 COPY syntax, which is
documented at the bottom of the COPY reference page, and hopefully not
used anywhere else.  FORCE_NULL isn't mentioned in that syntax, and
for that matter neither is FORCE NULL; if that works, it's accidental.

			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