Re: COPY manual is ambiguous about column list

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Pavlo Golub <pavlo(dot)golub(at)gmail(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: COPY manual is ambiguous about column list
Date: 2019-12-20 04:46:37
Message-ID: 12751.1576817197@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Bruce Momjian <bruce(at)momjian(dot)us> writes:
> How is the attached patch?

! In <command>COPY FROM</command>, the number of columns specified
! must match the number of fields in the file; any table columns not
! specified in the <command>COPY FROM</command> column list will insert
! their default values.

Phrasing seems a bit weird to me: you've run two nearly independent
observations into one sentence. But s/; any/. Any/ might be enough
to fix it.

regards, tom lane

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2019-12-20 05:07:48 Re: COPY manual is ambiguous about column list
Previous Message Jeff Janes 2019-12-19 20:54:44 Re: document effect of USAGE on foreign server to dblink