| From: | Matemática A3K <matematica(dot)a3k(at)gmail(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: [Minor] Conflicting sentence in "2.4. Populating a Table With Rows" |
| Date: | 2026-10-01 14:23:14 |
| Message-ID: | CA+FDnhKfO3VXe19CmrkQ7uTh=8diZrN1P7zgRijmAtWA=BfcGQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Thu, Oct 1, 2026 at 5:26 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:
> On Tue, 2026-09-29 at 15:00 -0300, Matemática A3K wrote:
> > > > Yeah, that last part could use some cleanup. I’d probably rewrite
> it using csv though instead of tab-delimited so as to remove the need for a
> parenthetical.
> > > >
> > > > David J.
> >
> > I'm attaching the patch although without the format that Laurenz used
> (not sure if it is needed though).
> >
> > It fixes the problem and removes the parenthetical, do you think is OK?
>
> No issue with the format of the patch, but with the content.
>
OK
The COPY statement uses the default tab-separated TEXT format, so your CSV
> data
> wouldn't work with it.
>
Good point, tab-separated should be what is shown to better align with the
command mentioned
> The wording in the documentation is confusing, because it does not indicate
> that the file below belongs to the COPY statement above.
>
I agree, it refers to another file and seems disjointed
> I think this should read:
>
> You could also have used COPY to load large amounts of data from
> flat-text files. [...]
> An example would be:
>
> COPY weather FROM '/home/user/weather.txt';
>
> where the file name for the source file must be available on the machine
> running the
> backend process, not the client, since the backend process reads the
> file directly.
> The file used in the <command>COPY</command> statement above could look
> as follows
> (the values are separated by a tab character):
>
> San Francisco 46 50 0.25 1994-11-27
> San Francisco 43 57 0.0 1994-11-29
> Hayward 37 54 \N 1994-11-29
>
I agree this is better, it is now crystal clear IMO. If David agrees, I'll
modify the patch to reflect this
>
> Yours,
> Laurenz Albe
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2026-10-01 15:02:21 | Re: [Minor] Conflicting sentence in "2.4. Populating a Table With Rows" |
| Previous Message | Laurenz Albe | 2026-10-01 08:26:35 | Re: [Minor] Conflicting sentence in "2.4. Populating a Table With Rows" |