I didn't know it. Is it only in psycopg2 that the name of the columns will use the name of the function?
The server assigns column names - hence the advice to use psql to investigate SQL issues more easily since there is one less moving part to deal with.
David J.