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