dgierejkiewicz/psycopg2_cheatsheet.md

Forked from pfigue/psycopg2_cheatsheet.md

Created November 18, 2021 11:33

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/dgierejkiewicz/dec8c5a106c3324bbb024125250b45c7.js"></script>
Save dgierejkiewicz/dec8c5a106c3324bbb024125250b45c7 to your computer and use it in GitHub Desktop.

Download ZIP

psycopg2 Cheatsheet

Raw

psycopg2_cheatsheet.md

Connect and Select

The shortest:

from psycopg2 import connect
psql_conn = connect("dbname=XXX user=XXX password=XXX host=localhost sslmode=require")

A little longer:

from psycopg2 import connect
# Establish psql connection
psql_creds = {
    'dbname': 'XXX',
    'user': 'XXX',
    'password': 'XXX',
    'host': 'localhost',
}
psql_creds_str = ' '.join(\
    ['%s=%s' % (k, psql_creds[k]) for k in psql_creds.keys()])
logger.debug('psql_creds_str: %s' % psql_creds_str)
psql_conn = connect(psql_creds_str)

Dictionary-like cursors

from psycopg2.extras import (DictCursor,)
dict_cur = conn.cursor(cursor_factory=DictCursor)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment