Get the latest PostgreSQL version available in a region

Question

Is there any gcloud cli command or api call that I can use to see the latest/newest available PostgreSQL versions in region?

I found db-versions page, but I need to check which is the latest/newest available version programmatically.

Answer 1

There is no a direct way to know this using gcloud CLI but I think the best (and awful) approach will be usign the help flag. Here are three versions so you can choose the one that could help you.

Version 1:

$ gcloud sql instances create --help | egrep -o '(MYSQL|POSTGRES)\w*'
MYSQL_5_5
MYSQL_5_6
MYSQL_5_7
POSTGRES_9_6
POSTGRES_11

Version 2:

$ gcloud sql instances create --help | egrep -o 'POSTGRES\w*'
POSTGRES_9_6
POSTGRES_11

Version 3:

$ gcloud sql instances create --help | egrep -o 'POSTGRES\w*' | egrep -o '_\w*' | sed -e 's/^.//' -e 's/_/./'
9.6
11

This versions will work assuming gcloud help is always updated.