‐‐‐‐‐‐‐ 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. Best regards, Maxim Fomin
