'show tables' equivalent for PostgreSQL

Here is a tip for refreshing the memory:

select relname from pg_stat_user_tables order by relname;