Postgres Copy To command

[R S]

I understand that \copy is available. However I have a HUGE query that COPY would work far better than \copy.

Is there anyway at all to use COPY TO with GCloud Postgres?

[Kenworth (Google Cloud Platform)]

COPY TO command is not available with Cloud SQL for PostgreSQL. As an alternative, you can use:

gcloud sql instances import (or export)

You can consult this article for more information about import and export.

[R S]

This doesn't help because you can't use a query. It's simple importing and exporting tables.

[Kenworth (Google Cloud Platform)]

True, it can only do 'table' granular import/export. For the use of COPY TO command, I highly encourage you to submit a feature request  as described in this article so that proper weight and attention be given to it. You can also refer on this thread as a background to the request.

[Chris Bandy]

Is the query large or are the results large? If it's the query, you should be able to pass it entirely to the psql \copy command in parentheses.

https://www.postgresql.org/docs/current/static/app-psql.html#app-psql-meta-commands-copy