Is there a way to query for the IP address (or other attributes) of the front-end process attached to a given backend? Perhaps something similar to: pg_stat_get_frontend_*( backendid ) -K ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match