Querying from information schema postgres

Does anyone know how to query from the system postgres tables?
e.g. something like SELECT * FROM pg_timezone_names
Was this page helpful?