Cloud SQL for PostgreSQL: Qwik Start

Overview

In this lab you'll learn how to create and connect to a Google Cloud SQL PostgreSQL instance and perform basic SQL operations using the Cloud Console and the psql client.

Task 1. Create a Cloud SQL instance

Click on the menu icon in the top left of the screen to see the Navigation menu ().
In the left menu of the Console, click on SQL.
Click Create Instance.
Click Choose PostgreSQL.
Create your instance with the following settings:

Enter myinstance for Instance ID.
Enter a password for the postgres user. Save or remember this password, you'll need it in the next section.
For Choose a Cloud SQL edition, select Enterprise.
For Region select europe-west1.
Leave the default values for the other fields.

Click Create Instance.

You are returned to the instances list. Your new instance is greyed out while it initializes and starts.

After a few minutes your instance is created and you can continue to the next section. If it seems to be taking a long time refresh your browser.

Test completed task

Click Check my progress to verify your performed task. If you have completed the task successfully you will granted with an assessment score.

Create a Cloud SQL instance

Check my progress

Task 2. Test your understanding

Below are multiple choice questions to reinforce your understanding of this lab's concepts. Answer them to the best of your abilities.

What PostgreSQL Database version used in lab to create Cloud SQL instance?15.45.75.61.0

Submit

Task 3. Connect to your instance using the psql client in the Cloud Shell

In the Cloud Console, click Cloud Shell () in the upper right corner.
Then click Continue if prompted.
At the Cloud Shell prompt, connect to your Cloud SQL instance by running:

gcloud sql connect myinstance --user=postgres

Enter your postgres password.

Note: The cursor will not move. Press Enter when you're done typing.

You should now see the psql prompt.

Task 4. Upload data into the postgres database

Insert sample data into the postgres database:

CREATE TABLE guestbook (guestName VARCHAR(255), content VARCHAR(255), entryID SERIAL PRIMARY KEY);
INSERT INTO guestbook (guestName, content) values ('first guest', 'I got here!');
INSERT INTO guestbook (guestName, content) values ('second guest', 'Me too!');

Retrieve the data:

SELECT * FROM guestbook;

You should now see:

 guestname   |   content   | entryid
--------------+-------------+---------
 first guest  | I got here! |       1
 second guest | Me too!     |       2
(2 rows)
postgres=>

You have created a Google Cloud SQL PostgreSQL instance and connected to it.

Task 5. Test your understanding

Below are multiple choice questions to reinforce your understanding of this lab's concepts. Answer them to the best of your abilities.

What is the name of default database in Postgres Cloud SQL instance?

information_schema
guestbook
performance_schema
postgres

Solution of Lab

New Solution

curl -LO raw.githubusercontent.com/ePlus-DEV/storage/refs/heads/main/labs/GSP152/lab.sh
source lab.sh

Old Solution

https://www.youtube.com/watch?v=MyqqjtnO5w0&feature=youtu.be

export REGION=

curl -LO raw.githubusercontent.com/quiccklabs/Labs_solutions/master/Cloud%20SQL%20for%20PostgreSQL%20Qwik%20Start/quicklabgsp152.sh
sudo chmod +x quicklabgsp152.sh
./quicklabgsp152.sh

Cloud SQL for PostgreSQL: Qwik Start - GSP152

Comments

Tip & Tricks

More from this blog

Daily Tech Brief — 10/08/2026

Daily Tech Brief — 09/08/2026

Daily Tech Brief — 08/08/2026

Daily Tech Brief — 07/08/2026

Knowledge Catalog: Qwik Start - Command Line - GSP1144

Overview

Task 1. Create a Cloud SQL instance

Task 2. Test your understanding

Task 3. Connect to your instance using the psql client in the Cloud Shell

Task 4. Upload data into the postgres database

Task 5. Test your understanding

Solution of Lab

New Solution

Old Solution

Command Palette

Comments

Tip & Tricks

More from this blog

Overview

Task 1. Create a Cloud SQL instance

Task 2. Test your understanding

Task 3. Connect to your instance using the psql client in the Cloud Shell

Task 4. Upload data into the postgres database

Task 5. Test your understanding

Solution of Lab

New Solution

Old Solution