1  SELECT * FROM pg_tables
2  WHERE schemaname = 'public'
3  ORDER BY tablename;