PostgreSQL数据库中表与文件的对应关系
发布时间:2020-12-13 16:41:17 所属栏目:百科 来源:网络整理
导读:postgres=# create table tab_lei (c1 int);CREATE TABLEpostgres=# postgres=# xExpanded display is on.postgres=# select relname,relfilenode from pg_class where relname='tab_lei';-[ RECORD 1 ]--------relname | tab_leirelfilenode | 49414postgr
postgres=# create table tab_lei (c1 int); CREATE TABLE postgres=# postgres=# x Expanded display is on. postgres=# select relname,relfilenode from pg_class where relname='tab_lei'; -[ RECORD 1 ]-------- relname | tab_lei relfilenode | 49414 postgres=# select oid,datname from pg_database where datname='postgres'; -[ RECORD 1 ]----- oid | 13212 datname | postgres postgres=# insert into tab_lei values(111); INSERT 0 1 postgres=# postgres=# select pg_relation_filepath('tab_lei'); pg_relation_filepath ---------------------- base/13212/49414 (1 row) postgres=# postgres=# q [postgres@pgserver data]$ cd $PGDATA/base [postgres@pgserver base]$ pwd /usr/local/pgsql/data/base [postgres@pgserver base]$ ls 1 13211 13212 16384 24838 [postgres@pgserver base]$ cd 13212 [postgres@pgserver 13212]$ ls -lrt |grep 49414 -rw------- 1 postgres postgres 8192 Mar 13 16:38 49414 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |