gcloud sql export sql --table option only uses first table in the list [147251210]

Assigned

Feature Request

Status Update

No update yet.

Description

ha...@science.doe.gov

created issue #1

Jan 7, 2020 06:43AM

I have a PostgreSQL 11 configuration, and I tried to use gcloud sql export sql --table to export three tables from a database. This did not work, however, and only the first table in the list was present in the resulting sql file.

I ran: gcloud sql export sql [INSTANCE_NAME] [URI] --database=[DB_NAME] --table=[TABLE1_NAME],[TABLE2_NAME],[TABLE3_NAME]

The documentation

https://cloud.google.com/sdk/gcloud/reference/sql/export/sql says that the supported syntax is

[--table=TABLE,[TABLE,…]

and, thus, I expected that providing a comma-separated list of table names would cause all of the tables named to appear in the SQL output file.

Comments

be...@google.com <be...@google.com> #2Jan 7, 2020 01:40PM

Assigned to gc...@google.com.

I have forwarded your request to our engineering team. I cannot provide an E.T.A. or guarantee that this feature will be deployed. Rest assured that your feedback is always seriously taken. Any future updates will be posted on this thread.

jk...@gmail.com <jk...@gmail.com> #3Aug 8, 2020 05:15AM

Is there any progress with that feature request?

jk...@gmail.com <jk...@gmail.com> #4Aug 13, 2020 06:47AM

I'm also very interested in having this extension in cloudsql for postgres since it's blocking the emigration of one of ours databases

jk...@gmail.com <jk...@gmail.com> #5Oct 7, 2020 05:46AM

+1 to voting for the ip4r extension. Currently not supported in Cloud SQL and we make use of it.

va...@gmail.com <va...@gmail.com> #6Nov 26, 2020 08:51PM

Any updates on this? It's blocking a migration from RDS to google cloud.

su...@google.com <su...@google.com> #7Apr 27, 2021 07:22AM

Reassigned to gc...@google.com.

This is now supported on Cloud SQL: https://cloud.google.com/sql/docs/postgres/extensions#data-type-extensions

ha...@melting-point.fr <ha...@melting-point.fr> #8Oct 20, 2021 09:21AM

Any updates, should we wait for a decade for this "small" feature.

dh...@rntbci.com <dh...@rntbci.com> #9Nov 12, 2021 09:23AM

Hi,
We do facing issues with multi table export option in Postgres SQL.
As mentioned by other, either a complete database export is possible or the only one table can be exported.

It would be great, if you provide the solution to either include or exclude the list of tables names during the sql data export.
Thanks for your support

Many users are awaiting to see this feature for postgresSQL

Message last modified on Nov 12, 2021 09:25AM

yo...@bt.com <yo...@bt.com> #10Apr 4, 2023 12:03PM

Hi Team,

Is there any update on these feature please?

la...@usps.gov <la...@usps.gov> #11Nov 7, 2024 06:10PM

Message last modified on Dec 4, 2024 08:35PM