Skip to content

Instantly share code, notes, and snippets.

@ryanaslett
Created February 2, 2017 22:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ryanaslett/6bcc723284ffd9f5a29ab86c9f3d0a35 to your computer and use it in GitHub Desktop.
Save ryanaslett/6bcc723284ffd9f5a29ab86c9f3d0a35 to your computer and use it in GitHub Desktop.
postgres=# select * from pg_class where pg_relation_filenode(oid) = 11685;
WARNING: terminal is not fully functional
relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids
| relhaspkey | relhasrules | relhastriggers | relhassubclass | relfrozenxid | relacl | reloptions
----------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------
+------------+-------------+----------------+----------------+--------------+---------------+------------
pg_class | 11 | 83 | 0 | 10 | 0 | 0 | 0 | 8 | 281 | 0 | 0 | t | f | p | r | 26 | 0 | t
| f | f | f | f | 670 | {=r/postgres} |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment