\dt information_schema.

从psql内部，应该没问题。

\dt information_schema.

从psql内部，应该没问题。

“\z”命令也是在交互式psql会话中列出表的好方法。

eg.

# psql -d mcdb -U admin -p 5555
mcdb=# /z
                           Access privileges for database "mcdb"
 Schema |              Name              |   Type   |           Access privileges
--------+--------------------------------+----------+---------------------------------------
 public | activities                     | table    |
 public | activities_id_seq              | sequence |
 public | activities_users_mapping       | table    |
[..]
 public | v_schedules_2                  | view     | {admin=arwdxt/admin,viewuser=r/admin}
 public | v_systems                      | view     |
 public | vapp_backups                   | table    |
 public | vm_client                      | table    |
 public | vm_datastore                   | table    |
 public | vmentity_hle_map               | table    |
(148 rows)

1.从information_schema中获取所有表和视图。表，包括information_schema和pg_catalog。

select * from information_schema.tables

2.获取属于特定模式的表和视图

select * from information_schema.tables
    where table_schema not in ('information_schema', 'pg_catalog')

3.只获取表(几乎\dt)

select * from information_schema.tables
    where table_schema not in ('information_schema', 'pg_catalog') and
    table_type = 'BASE TABLE'

对于postgresql中的私有模式xxx:

SELECT table_name FROM information_schema.tables 
 WHERE table_schema = 'xxx' AND table_type = 'BASE TABLE'

如果没有table_type = 'BASE TABLE'，你将列出表和视图

select * from information_schema.tables where table_schema = 'public' and table_type = 'BASE TABLE'

只订你们的桌子