python - PostgreSQL query and case sensitivity -

python - PostgreSQL query and case sensitivity -

i want assign case-sensitive alias column names in query, postgresql ignores case in alias , leaves lowercase. know stores in lowercase, want case sensitive alias in query. way working? renaming stuff manually after query execution huge dict sets sounds ridiculous.

update: of import note - i'm using amazon redshift. possible amazon limits it?

example

select superid supertable; ... cursor.execute(query) results = cursor.fetchall() row in results: print row['superid'] // ^ working ------------------------ select superid "superid" supertable; ... cursor.execute(query) results = cursor.fetchall() row in results: print row['superid'] // ^ not working

just try, may localization. seek different table or column names not contains "i". not superid may super.

python sql postgresql psycopg2 amazon-redshift