\u4e00\u3001pg_class:<\/p>\n
\u8be5\u7cfb\u7edf\u8868\u8bb0\u5f55\u4e86\u6570\u636e\u8868\u3001\u7d22\u5f15(\u4ecd\u7136\u9700\u8981\u53c2\u9605pg_index)\u3001\u5e8f\u5217\u3001\u89c6\u56fe\u3001\u590d\u5408\u7c7b\u578b\u548c\u4e00\u4e9b\u7279\u6b8a\u5173\u7cfb\u7c7b\u578b\u7684\u5143\u6570\u636e\u3002\u6ce8\u610f\uff1a\u4e0d\u662f\u6240\u6709\u5b57\u6bb5\u5bf9\u6240\u6709\u5bf9\u8c61\u7c7b\u578b\u90fd\u6709\u610f\u4e49\u3002 <\/code><\/pre>\n\u89c1\u5982\u4e0b\u5e94\u7528\u793a\u4f8b\uff1a<\/p>\n
\u67e5\u770b\u6307\u5b9a\u8868\u5bf9\u8c61testtable\u7684\u6a21\u5f0f<\/h1>\npostgres=# SELECT relname,relnamespace,nspname FROM pg_class c,pg_namespace n WHERE relname = 'testtable' AND relnamespace = n.oid;\n relname | relnamespace | nspname\n-------------+--------------+---------\n testtable | 2200 | public\n(1 row)\n#\u67e5\u770b\u6307\u5b9a\u8868\u5bf9\u8c61testtable\u7684owner(\u5373role)\u3002\npostgres=# select relname,rolname from pg_class c,pg_authid au where relname = 'testtable' and relowner = au.oid;\n relname | rolname\n-------------+----------\n testtable | postgres\n(1 row)<\/code><\/pre>\n\u4e8c\u3001pg_attribute:<\/p>\n
\u8be5\u7cfb\u7edf\u8868\u5b58\u50a8\u6240\u6709\u8868(\u5305\u62ec\u7cfb\u7edf\u8868\uff0c\u5982pg_class)\u7684\u5b57\u6bb5\u4fe1\u606f\u3002\u6570\u636e\u5e93\u4e2d\u7684\u6bcf\u4e2a\u8868\u7684\u6bcf\u4e2a\u5b57\u6bb5\u5728pg_attribute\u8868\u4e2d\u90fd\u6709\u4e00\u884c\u8bb0\u5f55\u3002<\/code><\/pre>\n\u89c1\u5982\u4e0b\u5e94\u7528\u793a\u4f8b\uff1a<\/p>\n
\u67e5\u770b\u6307\u5b9a\u8868\u4e2d\u5305\u542b\u7684\u5b57\u6bb5\u540d\u548c\u5b57\u6bb5\u7f16\u53f7\u3002<\/h1>\npostgres=# SELECT relname, attname,attnum FROM pg_class c,pg_attribute attr WHERE relname = 'testtable' AND c.oid = attr.attrelid;\n relname | attname | attnum\n-------------+----------+--------\n testtable | tableoid | -7\n testtable | cmax | -6\n testtable | xmax | -5\n testtable | cmin | -4\n testtable | xmin | -3\n testtable | ctid | -1\n testtable | i | 1\n(7 rows)\n#\u53ea\u67e5\u770b\u7528\u6237\u81ea\u5b9a\u4e49\u5b57\u6bb5\u7684\u7c7b\u578b\npostgres=# SELECT relname,attname,typname FROM pg_class c,pg_attribute a,pg_type t WHERE c.relname = 'testtable' AND c.oid = attrelid AND atttypid = t.oid AND attnum > 0;\n relname | attname | typname\n-------------+----------+---------\n testtable | i | int4\n(7 rows)<\/code><\/pre>\n\u4e09\u3001pg_attrdef:<\/p>\n
\u8be5\u7cfb\u7edf\u8868\u4e3b\u8981\u5b58\u50a8\u5b57\u6bb5\u7f3a\u7701\u503c\uff0c\u5b57\u6bb5\u4e2d\u7684\u4e3b\u8981\u4fe1\u606f\u5b58\u653e\u5728pg_attribute\u7cfb\u7edf\u8868\u4e2d\u3002\u6ce8\u610f\uff1a\u53ea\u6709\u660e\u786e\u58f0\u660e\u4e86\u7f3a\u7701\u503c\u7684\u5b57\u6bb5\u5728\u8be5\u8868\u4e2d\u624d\u4f1a\u6709\u8bb0\u5f55\u3002<\/code><\/pre>\n\u89c1\u5982\u4e0b\u5e94\u7528\u793a\u4f8b\uff1a<\/p>\n
\u67e5\u770b\u6307\u5b9a\u8868\u6709\u54ea\u4e9b\u5b57\u6bb5\u5b58\u5728\u7f3a\u7701\u503c\uff0c\u540c\u65f6\u663e\u793a\u51fa\u5b57\u6bb5\u540d\u548c\u7f3a\u7701\u503c\u7684\u5b9a\u4e49\u65b9\u5f0f<\/h1>\npostgres=# CREATE TABLE testtable2 (i integer DEFAULT 100);\nCREATE TABLE \npostgres=# SELECT c.relname, a.attname, ad.adnum, ad.adsrc FROM pg_class c, pg_attribute a, pg_attrdef ad WHERE relname = 'testtable2' AND ad.adrelid = c.oid AND adnum = a.attnum AND attrelid = c.oid;\n relname | attname | adnum | adsrc\n-------------+----------+---------+-------\n testtable2 | i | 1 | 100\n(1 row)<\/code><\/pre>\n\u56db\u3001pg_authid:<\/p>\n
\u8be5\u7cfb\u7edf\u8868\u5b58\u50a8\u6709\u5173\u6570\u636e\u5e93\u8ba4\u8bc1\u7684\u89d2\u8272\u4fe1\u606f\uff0c\u5728PostgreSQL\u4e2d\u89d2\u8272\u53ef\u4ee5\u8868\u73b0\u4e3a\u7528\u6237\u548c\u7ec4\u4e24\u79cd\u5f62\u5f0f\u3002\u5bf9\u4e8e\u7528\u6237\u800c\u8a00\u53ea\u662f\u8bbe\u7f6e\u4e86rolcanlogin\u6807\u5fd7\u7684\u89d2\u8272\u3002\u7531\u4e8e\u8be5\u8868\u5305\u542b\u53e3\u4ee4\u6570\u636e\uff0c\u6240\u4ee5\u5b83\u4e0d\u662f\u516c\u5171\u53ef\u8bfb\u7684\u3002PostgreSQL\u4e2d\u63d0\u4f9b\u4e86\u53e6\u5916\u4e00\u4e2a\u5efa\u7acb\u5728\u8be5\u8868\u4e4b\u4e0a\u7684\u7cfb\u7edf\u89c6\u56fepg_roles\uff0c\u8be5\u89c6\u56fe\u5c06\u53e3\u4ee4\u5b57\u6bb5\u586b\u6210\u7a7a\u767d\u3002<\/code><\/pre>\n\u89c1\u5982\u4e0b\u5e94\u7528\u793a\u4f8b\uff1a<\/p>\n
\u4ece\u8f93\u51fa\u7ed3\u679c\u53ef\u4ee5\u770b\u51fa\u53e3\u4ee4\u5b57\u6bb5\u5df2\u7ecf\u88ab\u52a0\u5bc6\u3002<\/h1>\npostgres=# SELECT rolname,rolpassword FROM pg_authid;\n rolname | rolpassword\n-----------+-------------------------------------\n postgres | md5a3556571e93b0d20722ba62be61e8c2d<\/code><\/pre>\n\u4e94\u3001pg_auth_members:<\/p>\n
\u8be5\u7cfb\u7edf\u8868\u5b58\u50a8\u89d2\u8272\u4e4b\u95f4\u7684\u6210\u5458\u5173\u7cfb\u3002<\/code><\/pre>\n\u89c1\u5982\u4e0b\u5e94\u7528\u793a\u4f8b\uff1a<\/p>\n
1. \u5148\u67e5\u770b\u89d2\u8272\u6210\u5458\u8868\u4e2d\u6709\u54ea\u4e9b\u89d2\u8272\u4e4b\u95f4\u7684\u96b6\u5c5e\u5173\u7cfb\uff0c\u5728\u5f53\u524d\u7ed3\u679c\u96c6\u4e2d\u53ea\u6709\u4e00\u4e2a\u6210\u5458\u89d2\u8272\u96b6\u5c5e\u4e8e\u4e00\u4e2a\u7ec4\u89d2\u8272\uff0c<\/h1>\n# \u5982\u679c\u6709\u591a\u4e2a\u6210\u5458\u89d2\u8272\u96b6\u5c5e\u4e8e\u540c\u4e00\u4e2a\u7ec4\u89d2\u8272\uff0c\u8fd9\u6837\u5c06\u4f1a\u6709\u591a\u6761\u8bb0\u5f55\u3002\npostgres=# SELECT * FROM pg_auth_members ;\n roleid | member | grantor | admin_option\n--------+--------+---------+--------------\n 16446 | 16445 | 10 | f\n(1 row)\n#2. \u67e5\u770b\u7ec4\u89d2\u8272\u7684\u540d\u5b57\u3002\npostgres=# SELECT rolname FROM pg_authid a,pg_auth_members am WHERE a.oid = am.roleid;\n rolname\n---------\n mygroup\n(1 row)\n#3. \u67e5\u770b\u6210\u5458\u89d2\u8272\u7684\u540d\u5b57\u3002\n#4. \u5982\u679c\u9700\u8981\u7528\u4e00\u4e2a\u7ed3\u679c\u96c6\u83b7\u53d6\u89d2\u8272\u4e4b\u95f4\u7684\u96b6\u5c5e\u5173\u7cfb\uff0c\u53ef\u4ee5\u5c06\u8fd9\u4e24\u4e2a\u7ed3\u679c\u96c6\u4f5c\u4e3a\u5b50\u67e5\u8be2\u540e\u518d\u8fdb\u884c\u5173\u8054\u3002\npostgres=# SELECT rolname FROM pg_authid a,pg_auth_members am WHERE a.oid = am.member;\n rolname\n---------\n myuser\n(1 row)<\/code><\/pre>\n\u516d\u3001pg_constraint:<\/p>\n
\u8be5\u7cfb\u7edf\u8868\u5b58\u50a8PostgreSQL\u4e2d\u8868\u5bf9\u8c61\u7684\u68c0\u67e5\u7ea6\u675f\u3001\u4e3b\u952e\u3001\u552f\u4e00\u7ea6\u675f\u548c\u5916\u952e\u7ea6\u675f\u3002<\/code><\/pre>\n\u4e03\u3001pg_tablespace:<\/p>\n
\u8be5\u7cfb\u7edf\u8868\u5b58\u50a8\u8868\u7a7a\u95f4\u7684\u4fe1\u606f\u3002\u6ce8\u610f\uff1a\u8868\u53ef\u4ee5\u653e\u5728\u7279\u5b9a\u7684\u8868\u7a7a\u95f4\u91cc\uff0c\u4ee5\u5e2e\u52a9\u7ba1\u7406\u78c1\u76d8\u5e03\u5c40\u548c\u89e3\u51b3IO\u74f6\u9888\u3002<\/code><\/pre>\n\u89c1\u5982\u4e0b\u5e94\u7528\u793a\u4f8b\uff1a<\/p>\n
1. \u521b\u5efa\u8868\u7a7a\u95f4\u3002<\/h1>\npostgres=# CREATE TABLESPACE my_tablespace LOCATION '\/opt\/PostgreSQL\/9.1\/mydata';\nCREATE TABLESPACE\n#2. \u5c06\u65b0\u5efa\u8868\u7a7a\u95f4\u7684CREATE\u6743\u9650\u8d4b\u4e88public\u3002\npostgres=# GRANT CREATE ON TABLESPACE my_tablespace TO public;\nGRANT\n#3. \u67e5\u770b\u7cfb\u7edf\u5185\u7528\u6237\u81ea\u5b9a\u4e49\u8868\u7a7a\u95f4\u7684\u540d\u5b57\u3001\u6587\u4ef6\u4f4d\u7f6e\u548c\u521b\u5efa\u5b83\u7684\u89d2\u8272\u540d\u79f0\u3002\n#4. \u7cfb\u7edf\u521b\u5efa\u65f6\u81ea\u52a8\u521b\u5efa\u7684\u4e24\u4e2a\u8868\u7a7a\u95f4(pg_default\u548cpg_global)\u7684\u6587\u4ef6\u4f4d\u7f6e\u4e3a\u7a7a(\u4e0d\u662fNULL)\u3002\npostgres=# SELECT spcname,rolname,spclocation FROM pg_tablespace ts,pg_authid a WHERE ts.spcowner = a.oid AND spclocation <> '';\n spcname | rolname | spclocation\n---------------+----------+----------------------------\n my_tablespace | postgres | \/opt\/PostgreSQL\/9.1\/mydata\n(1 row)<\/code><\/pre>\n\u516b\u3001pg_namespace:<\/p>\n
\u8be5\u7cfb\u7edf\u8868\u5b58\u50a8\u540d\u5b57\u7a7a\u95f4(\u6a21\u5f0f)\u3002<\/code><\/pre>\n\u89c1\u5982\u4e0b\u5e94\u7528\u793a\u4f8b\uff1a <\/p>\n
\u67e5\u770b\u5f53\u524d\u6570\u636e\u5e93public\u6a21\u5f0f\u7684\u521b\u5efa\u8005\u7684\u540d\u79f0\u3002<\/h1>\npostgres=# SELECT nspname,rolname FROM pg_namespace n, pg_authid a WHERE nspname = 'public' AND nspowner = a.oid;\n nspname | rolname\n----------+----------\n public | postgres\n(1 row)<\/code><\/pre>\n\u4e5d\u3001pg_database:<\/p>\n
\u8be5\u7cfb\u7edf\u8868\u5b58\u50a8\u6570\u636e\u5e93\u7684\u4fe1\u606f\u3002\u548c\u5927\u591a\u6570\u7cfb\u7edf\u8868\u4e0d\u540c\u7684\u662f\uff0c\u5728\u4e00\u4e2a\u96c6\u7fa4\u91cc\u8be5\u8868\u662f\u6240\u6709\u6570\u636e\u5e93\u5171\u4eab\u7684\uff0c\u5373\u6bcf\u4e2a\u96c6\u7fa4\u53ea\u6709\u4e00\u4efdpg_database\u62f7\u8d1d\uff0c\u800c\u4e0d\u662f\u6bcf\u4e2a\u6570\u636e\u5e93\u4e00\u4efd\u3002<\/code><\/pre>\n\u5341\u3001pg_index:<\/p>\n
\u8be5\u7cfb\u7edf\u8868\u5b58\u50a8\u5173\u4e8e\u7d22\u5f15\u7684\u4e00\u90e8\u5206\u4fe1\u606f\u3002\u5176\u5b83\u7684\u4fe1\u606f\u5927\u591a\u6570\u5b58\u50a8\u5728pg_class\u3002<\/code><\/pre>\n\u89c1\u5982\u4e0b\u5e94\u7528\u793a\u4f8b\uff1a<\/p>\n
\u67e5\u770b\u8be5\u7d22\u5f15\u6240\u5728\u8868\u7684\u540d\u79f0\uff0c\u4ee5\u53ca\u6784\u6210\u8be5\u7d22\u5f15\u7684\u952e\u503c\u6570\u91cf\u548c\u5177\u4f53\u952e\u503c\u7684\u5b57\u6bb5\u7f16\u53f7\u3002<\/h1>\npostgres=# SELECT indnatts,indkey,relname FROM pg_index i, pg_class c WHERE c.relname = 'testtable2' AND indrelid = c.oid;\n indnatts | indkey | relname\n----------+--------+------------\n 2 | 1 3 | testtable2\n(1 row)\n#\u67e5\u770b\u6307\u5b9a\u8868\u5305\u542b\u7684\u7d22\u5f15\uff0c\u540c\u65f6\u5217\u51fa\u7d22\u5f15\u7684\u540d\u79f0\u3002\npostgres=# SELECT t.relname AS table_name, c.relname AS index_name FROM (SELECT relname,indexrelid FROM pg_index i, pg_class c WHERE c.relname = 'testtable2' AND indrelid = c.oid) t, pg_index i,pg_class c WHERE t.indexrelid = i.indexrelid AND i.indexrelid = c.oid;\n table_name | index_name\n------------+----------------\n testtable2 | testtable2_idx\n(1 row)----------------------------------------------------------------------<\/code><\/pre>\n\u7cfb\u7edf\u89c6\u56fe<\/p>\n
\u4e00\u3001pg_tables:<\/p>\n
\u8be5\u89c6\u56fe\u63d0\u4f9b\u4e86\u5bf9\u6709\u5173\u6570\u636e\u5e93\u4e2d\u6bcf\u4e2a\u8868\u7684\u6709\u7528\u4fe1\u606f\u5730\u8bbf\u95ee\u3002<\/code><\/pre>\n\u4e8c\u3001pg_indexes:<\/p>\n
\u8be5\u89c6\u56fe\u63d0\u4f9b\u5bf9\u6570\u636e\u5e93\u4e2d\u6bcf\u4e2a\u7d22\u5f15\u7684\u6709\u7528\u4fe1\u606f\u7684\u8bbf\u95ee\u3002<\/code><\/pre>\n\u4e09\u3001pg_views:<\/p>\n
\u8be5\u89c6\u56fe\u63d0\u4f9b\u4e86\u5bf9\u6570\u636e\u5e93\u91cc\u6bcf\u4e2a\u89c6\u56fe\u7684\u6709\u7528\u4fe1\u606f\u7684\u8bbf\u95ee\u9014\u5f84\u3002<\/code><\/pre>\n\u56db\u3001pg_user:<\/p>\n
\u8be5\u89c6\u56fe\u63d0\u4f9b\u4e86\u5bf9\u6570\u636e\u5e93\u7528\u6237\u7684\u76f8\u5173\u4fe1\u606f\u7684\u8bbf\u95ee\u3002 \u8fd9\u4e2a\u89c6\u56fe\u53ea\u662fpg_shadow\u8868\u7684\u516c\u4f17\u53ef\u8bfb\u7684\u90e8\u5206\u7684\u89c6\u56fe\u5316\uff0c\u4f46\u662f\u4e0d\u5305\u542b\u53e3\u4ee4\u5b57\u6bb5\u3002<\/code><\/pre>\n\u4e94 pg_roles:<\/p>\n
\u8be5\u89c6\u56fe\u63d0\u4f9b\u8bbf\u95ee\u6570\u636e\u5e93\u89d2\u8272\u6709\u5173\u4fe1\u606f\u7684\u63a5\u53e3\u3002\u8fd9\u4e2a\u89c6\u56fe\u53ea\u662fpg_authid\u8868\u7684\u516c\u5f00\u53ef\u8bfb\u90e8\u5206\u7684\u89c6\u56fe\u5316\uff0c\u540c\u65f6\u628a\u53e3\u4ee4\u5b57\u6bb5\u7528\u7a7a\u767d\u586b\u5145\u3002<\/code><\/pre>\n\u516d\u3001pg_rules:<\/p>\n
\u8be5\u89c6\u56fe\u63d0\u4f9b\u5bf9\u67e5\u8be2\u91cd\u5199\u89c4\u5219\u7684\u6709\u7528\u4fe1\u606f\u8bbf\u95ee\u7684\u63a5\u53e3\u3002<\/code><\/pre>\n\u4e03\u3001pg_settings:<\/p>\n
\u8be5\u89c6\u56fe\u63d0\u4f9b\u4e86\u5bf9\u670d\u52a1\u5668\u8fd0\u884c\u65f6\u53c2\u6570\u7684\u8bbf\u95ee\u3002\u5b83\u5b9e\u9645\u4e0a\u662fSHOW\u548cSET\u547d\u4ee4\u7684\u53e6\u5916\u4e00\u79cd\u65b9\u5f0f\u3002\u5b83\u8fd8\u63d0\u4f9b\u4e00\u4e9b\u7528SHOW\u4e0d\u80fd\u76f4\u63a5\u83b7\u53d6\u7684\u53c2\u6570\u7684\u8bbf\u95ee\uff0c\u6bd4\u5982\u6700\u5927\u548c\u6700\u5c0f\u503c\u3002<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"\u4e00\u3001pg_class: \u8be5\u7cfb\u7edf\u8868\u8bb0\u5f55\u4e86\u6570\u636e\u8868\u3001\u7d22\u5f15(\u4ecd\u7136\u9700\u8981\u53c2\u9605pg_index)\u3001\u5e8f\u5217\u3001\u89c6\u56fe\u3001\u590d\u5408\u7c7b\u578b\u548c\u4e00\u4e9b\u7279\u6b8a\u5173\u7cfb\u7c7b\u578b\u7684\u5143\u6570\u636e\u3002\u6ce8\u610f\uff1a\u4e0d\u662f\u6240\u6709\u5b57\u6bb5\u5bf9\u6240\u6709\u5bf9\u8c61\u7c7b\u578b\u90fd\u6709\u610f\u4e49\u3002 \u89c1\u5982\u4e0b\u5e94\u7528\u793a\u4f8b\uff1a \u67e5\u770b\u6307\u5b9a\u8868\u5bf9\u8c61testtable\u7684\u6a21\u5f0f postgres=# SELECT relname,relnamespace,nspname FROM pg_class c,pg_namespace n WHERE relname = ‘testtable’ AND relnamespace = n.oid; relname | relnamespace | nspname ————-+————–+——— testtable | 2200 | public (1 row) #\u67e5\u770b\u6307\u5b9a\u8868\u5bf9\u8c61testtable\u7684owner(\u5373role)\u3002 postgres=# select relname,rolname from pg_class c,pg_authid au where relname = ‘testtable’ and relowner = au.oid; relname | rolname ————-+———- testtable | postgres (1 row) \u4e8c\u3001pg_attribute: \u8be5\u7cfb\u7edf\u8868\u5b58\u50a8\u6240\u6709\u8868(\u5305\u62ec\u7cfb\u7edf\u8868\uff0c\u5982pg_class)\u7684\u5b57\u6bb5\u4fe1\u606f\u3002\u6570\u636e\u5e93\u4e2d\u7684\u6bcf\u4e2a\u8868\u7684\u6bcf\u4e2a\u5b57\u6bb5\u5728pg_attribute\u8868\u4e2d\u90fd\u6709\u4e00\u884c\u8bb0\u5f55\u3002 \u89c1\u5982\u4e0b\u5e94\u7528\u793a\u4f8b\uff1a \u67e5\u770b\u6307\u5b9a\u8868\u4e2d\u5305\u542b\u7684\u5b57\u6bb5\u540d\u548c\u5b57\u6bb5\u7f16\u53f7\u3002 postgres=# SELECT relname, attname,attnum FROM pg_class c,pg_attribute attr WHERE relname = ‘testtable’ AND c.oid = attr.attrelid; relname | attname | attnum ————-+———-+——– testtable | tableoid | -7 testtable | cmax | -6 testtable | xmax | -5 testtable | cmin | -4 testtable | xmin | -3 testtable | ctid | -1 testtable | i | 1 (7 rows) #\u53ea\u67e5\u770b\u7528\u6237\u81ea\u5b9a\u4e49\u5b57\u6bb5\u7684\u7c7b\u578b postgres=# SELECT relname,attname,typname FROM pg_class c,pg_attribute a,pg_type t WHERE c.relname = ‘testtable’ AND c.oid = attrelid AND atttypid = t.oid AND attnum > 0; relname | attname | typname ————-+———-+——— testtable | i | int4 (7 rows) \u4e09\u3001pg_attrdef: \u8be5\u7cfb\u7edf\u8868\u4e3b\u8981\u5b58\u50a8\u5b57\u6bb5\u7f3a\u7701\u503c\uff0c\u5b57\u6bb5\u4e2d\u7684\u4e3b\u8981\u4fe1\u606f\u5b58\u653e\u5728pg_attribute\u7cfb\u7edf\u8868\u4e2d\u3002\u6ce8\u610f\uff1a\u53ea\u6709\u660e\u786e\u58f0\u660e\u4e86\u7f3a\u7701\u503c\u7684\u5b57\u6bb5\u5728\u8be5\u8868\u4e2d\u624d\u4f1a\u6709\u8bb0\u5f55\u3002 \u89c1\u5982\u4e0b\u5e94\u7528\u793a\u4f8b\uff1a \u67e5\u770b\u6307\u5b9a\u8868\u6709\u54ea\u4e9b\u5b57\u6bb5\u5b58\u5728\u7f3a\u7701\u503c\uff0c\u540c\u65f6\u663e\u793a\u51fa\u5b57\u6bb5\u540d\u548c\u7f3a\u7701\u503c\u7684\u5b9a\u4e49\u65b9\u5f0f postgres=# CREATE TABLE testtable2 (i integer DEFAULT 100); CREATE TABLE postgres=# SELECT c.relname, a.attname, ad.adnum, ad.adsrc FROM pg_class c, pg_attribute a, pg_attrdef ad WHERE relname = ‘testtable2’ AND ad.adrelid = c.oid AND adnum = a.attnum AND attrelid = c.oid; relname | attname | adnum | adsrc ————-+———-+———+——- testtable2 | i | 1 | 100 (1 row) \u56db\u3001pg_authid: \u8be5\u7cfb\u7edf\u8868\u5b58\u50a8\u6709\u5173\u6570\u636e\u5e93\u8ba4\u8bc1\u7684\u89d2\u8272\u4fe1\u606f\uff0c\u5728PostgreSQL\u4e2d\u89d2\u8272\u53ef\u4ee5\u8868\u73b0\u4e3a\u7528\u6237\u548c\u7ec4\u4e24\u79cd\u5f62\u5f0f\u3002\u5bf9\u4e8e\u7528\u6237\u800c\u8a00\u53ea\u662f\u8bbe\u7f6e\u4e86rolcanlogin\u6807\u5fd7\u7684\u89d2\u8272\u3002\u7531\u4e8e\u8be5\u8868\u5305\u542b\u53e3\u4ee4\u6570\u636e\uff0c\u6240\u4ee5\u5b83\u4e0d\u662f\u516c\u5171\u53ef\u8bfb\u7684\u3002PostgreSQL\u4e2d\u63d0\u4f9b\u4e86\u53e6\u5916\u4e00\u4e2a\u5efa\u7acb\u5728\u8be5\u8868\u4e4b\u4e0a\u7684\u7cfb\u7edf\u89c6\u56fepg_roles\uff0c\u8be5\u89c6\u56fe\u5c06\u53e3\u4ee4\u5b57\u6bb5\u586b\u6210\u7a7a\u767d\u3002 \u89c1\u5982\u4e0b\u5e94\u7528\u793a\u4f8b\uff1a…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[89],"tags":[],"class_list":["post-1641","post","type-post","status-publish","format-standard","hentry","category-postgres-db"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1641"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1641\/revisions"}],"predecessor-version":[{"id":1642,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1641\/revisions\/1642"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}