PostgreSQL List Tables

$pgsql

#select tablename from pg_tables where tablename not like '%pg_%';

will list all tables.