Python connect to PostgreSQL database

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

python-dotenv>=1.0.1

Python code

# Python code will be here

Code explanation

Example Python notebooks

Please find inspiration in example notebooks

• Backup table using python
• Connect to PostgreSQL database in Python
• Create new table using python and PostgreSQL
• From database to chart plotting
• Drop table using Python and PostgreSQL
• Fill PostgreSQL database with AI using Python
• Insert row into a table using Python
• Raw SQL query straight to pandas dataframe
• Run raw SQL query in python
• Select every column from table using python
• Show columns from table in PostgreSQL
• Show tables from PostgreSQL database
• Update column in table using Python
• Update selected rows of a column in table using python
• Transfer data from database to a Google sheet

Postgresql cookbook

Code recipes from Postgresql cookbook.

• Define a new connection
• Connect to database
• Show all tables
• Show all columns
• Raw query to Pandas
• Raw query
• Run select query
• Run insert query
• Update column
• Update selected
• Backup table
• Create table
• Drop table