Total Page Preview:   000000005640

How to get cloud SQL database list using cloudshell in gcp?

In this article I am going to explain how to get cloud sql database list in google cloud(gcp) cloudshell command.

 

Syntax 

gcloud sql databases list--instance=INSTANCE-i INSTANCE [--filter=EXPRESSION] [--limit=LIMIT] [--page-size=PAGE_SIZE]

 

Example

gcloud sql databases list --instance prod-instances

gcloud sql databases list --instance prod-instances  --format="json"

 

 

OUTPUT

NAME        CHARSET  COLLATION
postgres    UTF8     en_US.UTF8
dbPostGres  UTF8     en_US.UTF8
 

 

 

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com



Comments

Tiffany
02-Oct-2020
Hi friends, nice article and nice arguments commented here, I am actually enjoying by these.