How to run query in PostgreSQL | C2C Community
Solved

How to run query in PostgreSQL

  • 26 July 2022
  • 6 replies
  • 105 views

Userlevel 2
Badge +2

 

 

 

Created PostgreSQL instance and imported an SQL file. Unable to figure out from where to run the query.

icon

Best answer by malamin 26 July 2022, 15:01

View original

6 replies

Userlevel 7
Badge +56

You have either to open Cloud Shell and write everything there on the CLI or from BigQuery

Userlevel 2
Badge +2

 

 

Thanks for the support. Unable to locate techcosec instance (SQL instance created from SQL) from BigQuery.

Userlevel 7
Badge +56

Hi @DigitalSplendid,

if the check the Official Google Cloud documentation you can find everything.

For your case, you can read the Cloud SQL federated queries.

Userlevel 2
Badge +2

 

 

 

Unable to connect database and seeking help. Thanks!

Userlevel 7
Badge +13

HI @DigitalSplendid ,

@ilias already pointed important reference for your case. Also, I want to add extra credit resource for you. I think it will help you. Could you please check the following cloud skills boost quest link:

https://www.cloudskillsboost.google/quests/186

 

 

 

Lab-1: Migrate to Cloud SQL for PostgreSQL using Database Migration Service

Lab-2: Connect an App to a Cloud SQL for PostgreSQL Instance

Lab-3: Securing a Cloud SQL for PostgreSQL Instance

Lab-4: Configure Replication and Enable Point-in-Time-Recovery for Cloud SQL for PostgreSQL

Lab-5: Manage PostgreSQL Databases on Cloud SQL: Challenge Lab

You must set up a new cloud skills boost account if you don't already have one.

I hope it will solve your case. Click on lab to view the solution if all you want to do is look at it. Additionally, you can practice in the lab with a little amount of credit.

 

 

Userlevel 7
Badge +13

Thank you so much @ilias  and @DigitalSplendid to find value in my response.

Reply