Create a connection to PostgreSQL

    Follow these steps to create a connection to PostgreSQL:

    1. Select Visualization from the list of services on the left.

    2. Select your workbook or click Create workbook to make a new one.

    3. Click CreateConnection in the upper-right corner of your workbook page.

    4. Select PostgreSQL.

    5. Specify the connection parameters:

      • Hostname. IP address or the domain name (FQDN) of your host.

      • Port (by default, 6432).

      • Username and Password for your database.

      • Database name.

      • Cache TTL. Specifies how long to store cache. You can keep the Default value or select Customized to set this value manually.

      • Raw SQL level:

        • Forbid is the default setting. It handles all SQL queries automatically.

        • Allow subselects in datasets gives access to manual operations with SQL queries and subqueries. Use with caution and only if necessary.

        • Allow subselects in datasets and queries from charts allows you to use your connection to create a QL chart.

    6. Specify Advanced connection settings:

      • Select a value for Specifying collate in the request to set the sort order and character classification behavior. This value can be one of the following:

        • Auto (Depends on database settings)

        • On

        • Off

    7. Click Check connection:

      • If your connection is operational, you'll see a green icon.

      • If there is a problem, a red icon will appear. You'll also see a popup message with a Details button to check service information about the error.

    8. Click Create connection.

    9. Name your connection and click Create.