PostgreSQL: шпаргалка (use database, show tables, show users)

Небольшая шпаргалка для пользователей PostgreSQL, переключится в контекст базы (use database в mysql), список таблиц БД (show tables в mysql) и просмотр позьзователей имеющих доступ к базе данных.

Для работы с локальным сервером БД необходимо переключится в контекст пользователя postgres и запустить оснастку psql

[root@server ~]# sudo su -l postgres -c "psql"
psql (11.6 (Ubuntu 11.6-1.pgdg18.04+1), сервер 10.10 (Ubuntu 10.10-0ubuntu0.18.04.1))
Введите "help", чтобы получить справку
 
postgres=#

postgres=# \l
 
                        List of databases
Name       | Owner    | Encoding | Collate     | Ctype       | Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
quaded     | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
postgres   | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
template0  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
           |          |          |             |             | postgres=CTc/postgres
template1  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
           |          |          |             |             | postgres=CTc/postgres
(4 rows)
 
postgres=#

postgres=# \c quaded
You are now connected to database "quaded" as user "postgres".
quaded=#

quaded=# \dt
 
List of relations
Schema  | Name              | Type  | Owner
--------+-------------------+-------+-------
public  | alembic_version   | table | quaded
public  | flask_dance_oauth | table | quaded
public  | prices            | table | quaded
public  | product           | table | quaded
public  | user              | table | quaded
(5 rows)
 
quaded=#

quaded=# \dt+
 
List of relations
Schema  | Name              | Type  | Owner  | Size       | Description
--------+-------------------+-------+--------+------------+-------------
public  | alembic_version   | table | quaded | 8192 bytes |
public  | flask_dance_oauth | table | quaded | 16 kB      |
public  | prices            | table | quaded | 8192 bytes |
public  | product           | table | quaded | 16 kB      |
public  | user              | table | quaded | 8192 bytes |
(5 rows)

select * from product;