List Postgres tables and schemas in tablespaces

select relname, nspname as schema, spcname as tablespace from 
  pg_class cl, 
  pg_namespace ns, 
  pg_tablespace ts 
where 
  cl.relnamespace=ns.oid and 
  cl.reltablespace=ts.oid and 
  relkind='r';

Example output:

      relname       |   schema   | tablespace 
--------------------+------------+------------
 pg_authid          | pg_catalog | pg_global
 pg_database        | pg_catalog | pg_global
 pg_db_role_setting | pg_catalog | pg_global
 pg_tablespace      | pg_catalog | pg_global
 pg_pltemplate      | pg_catalog | pg_global
 pg_auth_members    | pg_catalog | pg_global
 pg_shdepend        | pg_catalog | pg_global
 pg_shdescription   | pg_catalog | pg_global
 pg_shseclabel      | pg_catalog | pg_global