‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Sunday, November 15, 2020 4:32 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Sunday, November 15, 2020, Maksim Fomin <maxim@fomin.one> wrote:
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Sunday, November 15, 2020, Maksim Fomin <maxim@fomin.one> wrote:
> plsql -d tsvt
psql (12.5)
Type "help" for help.
tsvt=# \dt+
List of relations
Schema | Name | Type | Owner | Size | Description
--------+------+-------+----------+---------+-------------
public | test | table | postgres | 0 bytes |
(1 row)
It should have tables 'trade', 'trade4' and some others.
What about?
\l+ (Letter “el”)
David J.
Well, it gives something:
tsvt=# \l+
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges | Size | Tablespace | Description
-----------+----------+----------+-------------+-------------+-----------------------+---------+------------+---------------------------
-----------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | 7809 kB | pg_default | default administrative con
nection database
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +| 7809 kB | pg_default | unmodifiable empty databas
e
| | | | | postgres=CTc/postgres | | |
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +| 8161 kB | pg_default | default template for new d
atabases
| | | | | postgres=CTc/postgres | | |
tsvt | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | 8089 MB | pg_default |
(4 rows)
tsvt is needed database and it has 8089 MB which sounds promising.
Show search_path;
?
David J.
It has:
tsvt=# Show search_path;
search_path
-----------------
"$user", public
(1 row)
'user' is literally the name of the current linux user.
Best regards,
Maxim Fomin