how to connect to PostgreSQL db and PGAdmin using Python | beginner-friendly tutorial

Опубликовано: 07 Апрель 2026
на канале: long.integer

806

In this episode, I am showing you how you can create your first table and insert data into a local PostgreSQL database from your IDE using Python.
We also use PGAdmin as an interface/dashboard to visualize it easier.

========================
⏱ Timestamps
0:00 Intro
1:00 Agenda
5:45 Downloading PGAdmin 4
9:54 What is PGAdmin 4, What you should focus on in the UI
15:25 what is PSYCOPG2 module?
17:00 How to connect from Python to your PostgreSQL database?
18:00 What is the connect( ) function?
25:00 What is the cursor( ) function?
28:25 Cursor in the Query Tool in PGAdmin 4
31:00 Your first query in Python and PGAdmin 4
1:04:00 Inserting into PostgreSQL from Python

53:00 GitHub CoPilot in action lol

========================

If you want to learn how to become a programmer and build automated software, this video is for you. Feel free to drop them in the comments or join our socials!

========================
🙋‍♂️Community Discord:
  / discord
https://theselfdev.com
blog.theselfdev.com
pomo.theselfdev.com

📲 Instagram:
  / self.devs

📩 Connect with me:
Instagram -   / long.integer
Twitch -   / longlikeshort
Twitter -   / longinteger017

Subscribers: 949
#pythonprogramming #pythontutorial #pythoncourse