Answers for "how to show tables in psql"

show table postgres command

PostgreSQL show tables command
	
\dt

show all tables postgres

\dt
# show list of tables in postgres

show tables postgresql way

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
timetable=> SELECT oid :: regclass AS table_name FROM pg_class WHERE relkind = 'r';
                table_name
--------------------------------------------
 timetable.chain_log
 pg_statistic
 pg_type
 timetable.dummy_log
...
 test
 location
(82 rows)
 
timetable=> SELECT * FROM pg_catalog.pg_tables;
     schemaname     |        tablename        | tableowner | tablespace | hasindexes | hasrules | hastriggers | rowsecurity
--------------------+-------------------------+------------+------------+------------+----------+-------------+-------------
 timetable          | chain_log               | scheduler  |            | t          | f        | f           | f
 pg_catalog         | pg_statistic            | pasha      |            | t          | f        | f           | f
 pg_catalog         | pg_type                 | pasha      |            | t          | f        | f           | f
 timetable          | dummy_log               | scheduler  |            | t          | f        | f           | f
...
(82 rows)