Re: Restoring database from false update

On Sunday, November 15, 2020, Maksim Fomin <maxim(at)fomin(dot)one> wrote:

>
>
> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
> On Sunday, November 15, 2020 4:32 PM, David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> On Sunday, November 15, 2020, Maksim Fomin <maxim(at)fomin(dot)one> wrote:
>
>> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
>> On Sunday, November 15, 2020 7:27 AM, David G. Johnston <
>> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>>
>> On Sunday, November 15, 2020, Maksim Fomin <maxim(at)fomin(dot)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.