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.
