I've got a lot of mileage out of the \copy command, which copies the results of a query into a client-local file https://www.postgresql.org/docs/12/app-psql.ht

I've got a lot of mileage out of the \copy command, which copies the results of a query into a client-local file https://www.postgresql.org/docs/12/app-psql.html#APP-PSQL-META-COMMANDS-COPY https://www.postgresql.org/docs/12/app-psql.html#APP-PSQL-ME...