Making gethostbyaddr accessible in PostgreSQL via Python

gistfile1.sql

CREATE PROCEDURAL LANGUAGE 'plpythonu';

CREATE OR REPLACE FUNCTION gethostbyaddr(address text)
  RETURNS text
  LANGUAGE plpythonu
AS $$
  import socket
  
  try:
    return socket.gethostbyaddr(address)[1][0]
  except:
    return None
$$;