zero-postgres 0.3.2

A high-performance PostgreSQL client
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

import psycopg

# Connect to the database
conn = psycopg.connect("postgres://test:1234@localhost/test?sslmode=disable")

print("=== Small int (42) ===")
cur = conn.execute("SELECT %s", (42,))
result = cur.fetchone()
print(f"Value: {result[0]}, Type: {type(result[0])}, PG type: {cur.description[0].type_code}")

print("\n=== Large int (100000) ===")
cur = conn.execute("SELECT %s", (100000,))
result = cur.fetchone()
print(f"Value: {result[0]}, Type: {type(result[0])}, PG type: {cur.description[0].type_code}")

print("\n=== Very large int (10**18) ===")
cur = conn.execute("SELECT %s", (10**18,))
result = cur.fetchone()
print(f"Value: {result[0]}, Type: {type(result[0])}, PG type: {cur.description[0].type_code}")

print("\n=== Huge int (10**100) ===")
cur = conn.execute("SELECT %s", (10**100,))
result = cur.fetchone()
print(f"Value: {result[0]}, Type: {type(result[0])}, PG type: {cur.description[0].type_code}")

conn.close()