#-*-coding:utf-8
import psycopg2
import pandas as pd
import numpy as np
import csv
import sql
from sqlalchemy import create_engine
kse0202
/ python_postgres_table_download_update.md
Last active
July 11, 2023 04:43
Jupyter Notebook에서 python으로 1. postgresql DB에 접속 2. DB내 테이블 DataFrame으로 가져오기 3. DataFrame을 기존 DB내 테이블에 업데이트
cabecada
/ gist:da8913830960a644755b18a02b65e184
Last active
January 14, 2025 16:00
python postgres connection with retry example
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env python | |
| #https://github.com/psycopg/psycopg2/issues/261 | |
| import psycopg2 | |
| ISOLEVEL = psycopg2.extensions.ISOLATION_LEVEL_AUTOCOMMIT | |
| import time |