PGSQL 列出所有的表

可以直接使用 SQL 列出所有的表:

SELECT tablename 
FROM pg_tables 
WHERE schemaname = 'public';

或者输入 \dt 也可以。

isharkfly_www=# \dt
                            List of tables
 Schema |                   Name                   | Type  |  Owner
--------+------------------------------------------+-------+----------
 public | admin_notices                            | table | postgres
 public | ai_api_audit_logs                        | table | postgres
 public | ai_artifact_key_values                   | table | postgres
 public | ai_artifact_versions                     | table | postgres
 public | ai_artifacts                             | table | postgres
 public | ai_moderation_settings                   | table | postgres
 public | ai_personas                              | table | postgres
 public | ai_spam_logs                             | table | postgres
 public | ai_summaries                             | table | postgres
 public | ai_tools                                 | table | postgres
 public | allowed_pm_users                         | table | postgres
 public | anonymous_users                          | table | postgres
 public | api_key_scopes                           | table | postgres
 public | api_keys                                 | table | postgres
 public | application_requests                     | table | postgres
 public | ar_internal_metadata                     | table | postgres
 public | assignments                              | table | postgres
 public | associated_groups                        | table | postgres
 public | backup_draft_posts                       | table | postgres
 public | backup_draft_topics                      | table | postgres
 public | backup_metadata                          | table | postgres
 public | badge_groupings                          | table | postgres
 public | badge_types                              | table | postgres
 public | badges                                   | table | postgres
 public | bookmarks                                | table | postgres
 public | calendar_events                          | table | postgres
 public | categories                               | table | postgres
 public | categories_web_hooks                     | table | postgres