Connecting to PostgreSQL - Python Connector for PostgreSQL

Connecting to PostgreSQL

To establish a connection to a PostgreSQL database, import the connector and use the connect() method with your connection parameters.

Step 1. Import the connector

First, import the PostgreSQL connector module:

import devart.postgresql as postgresql

Step 2. Establish a connection

Call the connect() method and obtain a connection object.

my_connection = postgresql.connect(
    Server="your_server",
    Database="your_database",
    UserId="your_username",
    Password="your_password"
)

Replace the example values with your actual connection values.

For more information, see Connection parameters.