MIME-Version: 1.0
References: 
 <CA+dvXXvA+=9fsf-C0HuPG4CGed12SSaL1T+yM4rLU6mgDOfkiQ@mail.gmail.com>
In-Reply-To: 
 <CA+dvXXvA+=9fsf-C0HuPG4CGed12SSaL1T+yM4rLU6mgDOfkiQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 8 Aug 2024 10:44:04 -0400
Message-ID: 
 <CANzqJaCYnDHexB-QucpAtK8AZ6Aj8eyHKhDjwHjy+eENFuxZ7g@mail.gmail.com>
Subject: Re: Export Query Output to incremental csv file
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000099a7b8061f2d0fe8"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaCYnDHexB-QucpAtK8AZ6Aj8eyHKhDjwHjy%2BeENFuxZ7g%40mail.gmail.com>
Precedence: bulk

--00000000000099a7b8061f2d0fe8
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Aug 8, 2024 at 10:26=E2=80=AFAM Erik Serrano <eserranos@gmail.com> =
wrote:

> Hi guys,
> I would like to ask a question about exporting a query output to a csv
> file but with the particularity that it is incremental (that is, the same
> file grows in size) since I need to do the query multiple times and I don=
't
> want to fill up with csv files... but rather just one that always grows, =
as
> if it were a log.
>
> I will add the query to a shell and schedule it using a crontab in Linux
> Centos.
>

COPY ... TO STDOUT, and then append that to the CSV file using ">>".

(Unless I misinterpret what you mean.)

--=20
Death to America, and butter sauce.
Iraq lobster!

--00000000000099a7b8061f2d0fe8
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Aug 8, 2024 at 10:26=E2=80=AFAM E=
rik Serrano &lt;<a href=3D"mailto:eserranos@gmail.com">eserranos@gmail.com<=
/a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gma=
il_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,2=
04,204);padding-left:1ex"><div dir=3D"ltr">Hi guys,<br>I would like to ask =
a question about exporting a query output to a csv file but with the partic=
ularity that it is incremental (that is, the same file grows in size) since=
 I need to do the query multiple times and I don&#39;t want to fill up with=
 csv files... but rather just one that always grows, as if it were a log.<b=
r><br>I will add the query to a shell and schedule it using a crontab in Li=
nux Centos.<br></div></blockquote><div><br></div><div>COPY ... TO STDOUT, a=
nd then append that to the CSV file using &quot;&gt;&gt;&quot;.</div><div><=
br></div><div>(Unless I misinterpret what you mean.)</div></div><div><br></=
div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" c=
lass=3D"gmail_signature"><div dir=3D"ltr">Death to America, and butter sauc=
e.<div>Iraq lobster!</div></div></div></div>

--00000000000099a7b8061f2d0fe8--