Re: [GENERAL] Redo the filenode link in tablespace - Mailing list pgsql-general

From Adrian Klaver
Subject Re: [GENERAL] Redo the filenode link in tablespace
Date
Msg-id 7333a726-5c01-ccbf-bc60-97026c1c0106@aklaver.com
Whole thread Raw
In response to Re: [GENERAL] Redo the filenode link in tablespace  (tel medola <tel.medola@gmail.com>)
Responses Re: [GENERAL] Redo the filenode link in tablespace  (tel medola <tel.medola@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: tel medola
Date:
Subject: Re: [GENERAL] Redo the filenode link in tablespace
Next
From: Albe Laurenz
Date:
Subject: Re: [GENERAL] Writing a C function to return the log file name