您可以使用类似下面的方法获取列名

select ordinal_position as position,
       column_name,
       data_type,
       case when character_maximum_length is not null
            then character_maximum_length
            else numeric_precision end as max_length,
       is_nullable,
       column_default as default_value
from information_schema.columns
where table_name = 'table_name'
      and table_schema = 'Schema name'
order by ordinal_position;

您也可以尝试https://docs.aws.amazon.com/redshift/latest/dg/r_PG_TABLE_DEF.html

谢谢乔恩·斯科特的回应，但我在这里创造了我想要的答案，也许它能帮助到某人...

curs = conn.cursor()
curs.execute("select u.customer_name, u.status, from table.users u limit 10")
# This next line was the key:
colnames = [desc[0] for desc in curs.description]
result = curs.fetchall()

# Then converting to Pandas DataFrame and adding the column names
df = pd.DataFrame(result)
df.columns = colnames

谢谢！