Skip to content

Latest commit

 

History

History
16 lines (11 loc) · 563 Bytes

SQL.md

File metadata and controls

16 lines (11 loc) · 563 Bytes
Raw

PostgreSQL

SELECT table_name FROM information_schema.tables WHERE table_schema='public'

  • When create the database with docker-compose, remember to delete the database if changing it.

  • Insert data to the database: Must commit the change

cursor.execute("insert into products(id, name) values (?, ?)", 'pyodbc', 'awesome library')
cnxn.commit()