Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
krace@hotbox /m/u/code> cat
import psycopg2
def run(stmt):
cur = psycopg2.connect(database='test', user='postgres', password='password', host='localhost').cursor()
result = cur.fetchall()
stmt = 'select row_to_json(row) from (select,, book.author_id, as author_name from book inner join author on book.author_id = row;'
krace@hotbox /m/u/code> python
[({'id': 1, 'author_id': 1, 'name': 'War and Peace', 'author_name': 'Leo Tolstoy'},),
({'id': 2, 'author_id': 2, 'name': 'The Trial', 'author_name': 'Kafka'},),
({'id': 3, 'author_id': 2, 'name': 'The metamorphosis', 'author_name': 'Kafka'},)]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.