python
from twisted.internet import defer
from twisted.internet import reactor
from txpostgres import txpostgres
dsn = "dbname=test user=postgres password=123456"
@defer.inlineCallbacks
def execute_query(conn):
result = yield conn.runQuery("SELECT * FROM users")
print(result)
reactor.stop()
pool = txpostgres.ConnectionPool(txpostgres.Connection, dsn=dsn)
pool.start()
pool.connected.addCallback(execute_query)
reactor.run()
