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 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.