@pytest.fixture
def db_conn():
    conn = psycopg2.connect("dbname=test user=postgres")
    return conn

def test_foo(db_conn):
    result = db_conn.execute(a_sql_statement)
    assert result == expected_value