📋Steps in this guide1/1

Find respective physical file of a table/index

-- For getting the physical location of a table:

postgresql configurationintermediate

by PostgreSQL

11 views

Find respective physical file of a table/index

-- For getting the physical location of a table: -- For getting the physical location of an index:

Code/Command (click line numbers to comment):

postgres=#
select pg_relation_filepath('test');
pg_relation_filepath
----------------------
base/13635/17395
(1 row)
postgres=#
select pg_relation_filepath('test_idx');
pg_relation_filepath
----------------------
base/13635/17638
(1 row)

Comments (0)

Please to add comments

No comments yet. Be the first to comment!