Python send raw query to PostgreSQL

Simply run a sql query. You can input any valid Postgresql sql query. Select query will display the result. Credentials are loaded from .env file. Any errors in query will raise an exception.

pythonpostgresqlsqlpsycopg.env

Required packages

You need below packages to use the code generated by recipe. All packages are automatically installed in MLJAR Studio.

psycopg>=3.2.1

Interactive recipe

You can use below interactive recipe to generate code. This recipe is available in MLJAR Studio.

In the below recipe, we assume that you have following variables available in your notebook:

conn (type Connection)

Python code

# Python code will be here

Code explanation

Check if there is an open connection.
If not then open the connection.
Try to run query.
If error occurs raise exception.
If run a select query, fetch and show the result.

Example Python notebooks

Please find inspiration in example notebooks

Run raw SQL query in python

Postgresql cookbook

Code recipes from Postgresql cookbook.

« Previous: Raw query to Pandas
Next »: Run select query