GreenPlum - Get field types

 

import psycopg2conn = psycopg2.connect(dbname="your_db",user="your_user",password="your_password",host="your_host",port="5432"
)
cur = conn.cursor()cur.execute("""SELECT column_name, data_typeFROM information_schema.columnsWHERE table_schema = 'public' AND table_name = 'your_table'ORDER BY ordinal_position;
""")for name, dtype in cur.fetchall():print(name, dtype)cur.close()
conn.close()