psycopg2: Connect Python to PostgreSQL Database

preview_player

Показать описание

Here is how the psycopg2 library can be used to connect Python to a PostgreSQL database.

Рекомендации по теме

Комментарии

you use python fron unix or linux system but for windows?

ericserve

how to check all table name in the data base using pyhton

MrNabiwishes

hi,

how I make truncate table ? I need truncate = "xxx.xxx".testing

"xxx.xxx" = name schema
testing = name table

tomasstefanec

Thanks Michael for making this video. Could you export the table to a CSV file using psycopg2?

alicehou

to establish the connection after entering the database, how to find out the username ?

sudarshankodancha

Im unable to fetch the row s by using this line cur.execute("SELECT * from Employee")
the error it shows ProgrammingError: relation "employee" does not exist
LINE 1: SELECT * from Employee

please help me out

sazan