Learn how to list tables in PostgreSQL with multiple methods including information schema queries, psql commands, and system catalog queries. Complete guide with examples for MySQL users.