Postgres - List tables - til.duyet.net

til.duyet.net

Search…

Postgres - List tables

Using psql
1
\dt
Copied!
1
# \dt
2
             List of relations
3
 Schema |     Name      | Type  |  Owner
4
--------+---------------+-------+----------
5
 public | actor         | table | postgres
6
 public | address       | table | postgres
7
 public | category      | table | postgres
8
 ....
Copied!
Using pg_catalog schema
1
SELECT
2
   *
3
FROM
4
   pg_catalog.pg_tables
5
WHERE
6
   schemaname != 'pg_catalog'
7
AND schemaname != 'information_schema';
Copied!
Reference:
​http://www.postgresqltutorial.com/postgresql-show-tables/​

Postgres - Index Summary

Redshift - GRANT

Last modified 2yr ago

Copy link

Edit on GitHub

Contents

Using psql

Using pg_catalog schema