Quickstart for Cloud SQL for PostgreSQL

This page shows you how to create and connect to a Google Cloud SQL PostgreSQL instance and perform basic SQL operations using the Google Cloud Platform Console and the psql client.

Before you begin

  1. Sign in to your Google account.

    If you don't already have one, sign up for a new account.

  2. Select or create a Cloud Platform project.

    Go to the Projects page

  3. Enable billing for your project.

    Enable billing

  4. Enable the Cloud SQL Administration API.

    Enable the API

Create a Cloud SQL instance

  1. Go to the Cloud SQL Instances page in the Google Cloud Platform Console.

    Go to the Cloud SQL Instances page

  2. Select your project and click Continue.

  3. Click Create Instance.
  4. Click PostgreSQL.
  5. Enter myinstance for Instance ID.

    Screenshot of the top part of the instance creation screen

  6. Enter the password for the postgres user.

    Use the default values for the other fields.

  7. At the bottom of the page, click Create.

    Screenshot of the create button at the bottom of the creation screen

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

Connect to your instance using the psql client in the Cloud Shell

  1. In the Google Cloud Platform Console, click the Cloud Shell icon (Cloud Shell
icon) in the upper right corner.

    When the Cloud Shell finishes initializing, you should see:

    Welcome to Cloud Shell! Type "help" to get started.
    username@example-id:~$
    

  2. At the Cloud Shell prompt, connect to your Cloud SQL instance:

    gcloud sql connect myinstance --user=postgres
    
  3. Enter your postgres password.

    You should see the psql prompt.

Create a database and upload data

  1. 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!');
    
  2. Retrieve the data:
    SELECT * FROM guestbook;
    
    You should see:
      guestname   |   content   | entryid
    --------------+-------------+---------
     first guest  | I got here! |       1
     second guest | Me too!     |       2
    (2 rows)
    postgres=>
    

Clean up

To avoid incurring charges to your Google Cloud Platform account for the resources used in this quickstart:

  1. Go to the Cloud SQL Instances page in the Google Cloud Platform Console.
    Go to the Cloud SQL Instances page
  2. Select the myinstance instance to open the Instance details page.
  3. In the icon bar at the top of the page, click Delete.
  4. In the Delete instance window, type myinstance, then click Delete to delete the instance.

    Screenshot of the delete dialog

    You cannot reuse an instance name for approximately 7 days after an instance is deleted.

What's next

Send feedback about...

Cloud SQL for PostgreSQL