select 
*
from pg_class
where oid= 24209;

vacuum

vacuum full

vacuum

vacuum full

select oid, relname from pg_class where pg_relation_filepath(oid)='base/16393/24209';

select oid, relname,relkind
from pg_class where pg_relation_filepath(oid)='base/16393/24209';

ERROR:  function pg_relation_filepath(oid) does not exist
LINE 1: select oid, relname from pg_class where pg_relation_filepath...
                                                ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
********** Ошибка **********

ERROR: function pg_relation_filepath(oid) does not exist
SQL-состояние: 42883
Подсказка: No function matches the given name and argument types. You might need to add explicit type casts.
Символ: 41

select 
    n.nspname AS tableschema, 
    c.relname AS tablename
from pg_class c
inner join pg_namespace n on (c.relnamespace = n.oid)
where c.relfilenode = 24209;

ERROR:  function pg_relation_filepath(oid) does not exist
LINE 1: select oid, relname from pg_class where pg_relation_filepath...
                                                ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
********** Ошибка **********

ERROR: function pg_relation_filepath(oid) does not exist
SQL-состояние: 42883
Подсказка: No function matches the given name and argument types. You might need to add explicit type casts.
Символ: 41

select 
    n.nspname AS tableschema, 
    c.relname AS tablename
from pg_class c
inner join pg_namespace n on (c.relnamespace = n.oid)
where c.relfilenode = 24209;

select 
    n.nspname AS tableschema, 
    c.relname AS tablename
from pg_class c
inner join pg_namespace n on (c.relnamespace = n.oid)
where c.relfilenode = 24209;

SELECT oid,datname FROM pg_database ;