gistfile1.py

from sqlalchemy import create_engine
import logging
logging.basicConfig(filename = "sqlalchemypy3.log")
logging.getLogger('sqlalchemy.engine').setLevel(logging.INFO)

engine = create_engine("postgresql+pg8000://postgres@localhost:15432/pg8000")
c = engine.connect()
c.execute("delete from prueba")
words = "first look at sqlalchemy from python3 using pg8000 module"
aWords = ["('{0}')".format(x) for x in words.split()]
sql = "insert into prueba(nombre) values {0} returning nombre".format(",".join(aWords))

for row in c.execute(sql):
        print(row["nombre"])

print("\nahora los tuples ordenados por nombre\n")
sql = "select nombre from prueba order by nombre"
for row in c.execute(sql):
        print(row["nombre"])
c.close()