Get Tables in PostgreSQL (Postgres)

This is how you get a list of tables in Postgres.

SELECT tablename FROM pg_tables
WHERE tablename NOT LIKE ‘pg\\_%’
AND tablename NOT LIKE ’sql\\_%’,
order by tablename;