On Sunday, November 15, 2020, Maksim Fomin <ma...@fomin.one> wrote: > > > ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ > On Sunday, November 15, 2020 4:32 PM, David G. Johnston < > david.g.johns...@gmail.com> wrote: > > On Sunday, November 15, 2020, Maksim Fomin <ma...@fomin.one> wrote: > >> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ >> On Sunday, November 15, 2020 7:27 AM, David G. Johnston < >> david.g.johns...@gmail.com> wrote: >> >> On Sunday, November 15, 2020, Maksim Fomin <ma...@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. >
How about \dn David J.
