postgresql psycopg2 select single value

Solutions on MaxInterview for postgresql psycopg2 select single value by the best coders in the world

showing results for - "postgresql psycopg2 select single value"

16 Oct 2018

1#!/usr/bin/env python
2# -*- coding: utf-8 -*-
3
4import psycopg2
5import sys
6
7con = None
8
9try:
10
11    con = psycopg2.connect(database='testdb', user='postgres',
12        password='s$cret')
13
14    cur = con.cursor()
15    cur.execute('SELECT version()')
16
17    version = cur.fetchone()[0]
18    print(version)
19
20except psycopg2.DatabaseError as e:
21
22    print(f'Error {e}')
23    sys.exit(1)
24
25finally:
26
27    if con:
28        con.close()
29

source

similar questions

select from array in psql psql datetime grather than copy value from one column to another postgres substract variable amount of minutes from timestamp postgresql copy data from one postgres container to another postgres row expiration postgres select from last 3 months postgres copy command copy from one table to another postgres using matching column current date in postgresql minus 1 day psql store procedure return multiple table values postgresql gset postgres select from values postgresql string agg postgres multiple left join causing duplicates jsonb agg postgresql group by month and year psql select 2a from table how to combine diff colmun value using group by postgres postgres select duplicate columns