Re: [GENERAL] Redo the filenode link in tablespace

On 06/06/2017 04:40 AM, tel medola wrote:

Lets go:
In my plsql:
rai=# select oid, * from pg_class where relfilenode = 5214489;

I was looking for:

select oid, * from pg_class where oid = 5214493;

Result:
    oid   |   relname   | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages |  reltuples   | relallvisible | reltoastrelid | reltoastidxid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids | relhaspkey | relhasrules | relhastriggers | relhassubclass | relispopulated | relfrozenxid | relminmxid | relacl | reloptions
---------+-------------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+--------------+---------------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------+------------+-------------+----------------+----------------+----------------+--------------+------------+--------+------------
  5214489 | repositorio |      5205962 | 5214491 |         0 |       10 |     0 |     5214489 |       5205910 |    79303 | 1.31566e+006 |          79303 |       5214493 |             0 | t           | f           | p               | r       |        7 |         0 | f          | t           | f           | f              | f              | t              |       9360288 |          1 |        |
(1 registro)

Ok?

--
Adrian Klaver
adrian.klaver@aklaver.com