PostgreSQL: \dt

From wikieduonline
Revision as of 09:01, 29 October 2021 by Welcome (talk | contribs)
Jump to navigation Jump to search

https://www.postgresql.org/docs/current/app-psql.html


\dt
                           List of relations
 Schema |               Name                | Type  |       Owner
--------+-----------------------------------+-------+-------------------
 public | yourtable1                            | table | rds_master
 public | yourtable2                            | table | rds_master
 public | yourtable3                            | table | other_user
 public | yourtable4                            | table | rds_master


\dt *.*: List tables from all schemas (if *.* is omitted will only show SEARCH_PATH ones) [1]


\dE[S+]: List all foreign tables [2]

Related

See also

  • https://gist.github.com/Kartones/dd3ff5ec5ea238d4c546
  • https://gist.github.com/Kartones/dd3ff5ec5ea238d4c546
  • Advertising: