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 Klaveradrian.klaver@aklaver.com
Lets go: In my plsql: rai=# select oid, * from pg_class where relfilenode = 5214489;
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?
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных