반응형
/********************************************************************************************
-- Title : [PGS9.2] 테이블, 인덱스가 저장된 물리적 파일 위치 찾기
-- Reference : http://postgresql.1045698.n5.nabble.com/How-to-get-the-phys...
-- Key word : oid pg_relation_filepath
********************************************************************************************/
postgres=# select pg_relation_filepath('sch_ttt.aaa');
pg_relation_filepath
----------------------
base/12870/16429
(1 row)
postgres=# select pg_relation_filepath('public.aaa');
pg_relation_filepath
----------------------
base/12870/16425
(1 row)
반응형