基于postgresql查询某个字段属于哪个表的说明

SELECT *

FROM information_schema. COLUMNS

WHERE COLUMN_NAME = 'storename' ;

SELECT c.relname AS "表名" ,a.attname AS "字段名" ,c.oid

FROM pg_class c

LEFT JOIN pg_attribute a ON a.attrelid = c.oid

WHERE c.relname NOT LIKE 'pg_%'

-- AND c.relname = 'kx_store'

AND a.attname = 'storename' ;

SELECT AA.*,BB. DESC FROM

  (

SELECT

A.ORDINAL_POSITION AS COL_NUM,

A.COLUMN_NAME AS COL_NAME,

A.DATA_TYPE AS COL_TYPE,

A.CHARACTER_MAXIMUM_LENGTH AS COL_LEN,

A.NUMERIC_PRECISION AS COL_PREC,

A.DATETIME_PRECISION AS COL_TIME_PREC,

A.IS_NULLABLE AS COL_NULLABLE,

A.COLUMN_DEFAULT AS COL_DEFAULT

FROM INFORMATION_SCHEMA.COLUMNS A

WHERE A.TABLE_SCHEMA = 'public' AND A.TABLE_NAME = 'table_name'

  )

  AS AA LEFT JOIN

  (

SELECT

OBJSUBID,

DESCRIPTION AS DESC

FROM PG_DESCRIPTION

WHERE OBJOID =

(

  SELECT RELID FROM PG_STAT_ALL_TABLES WHERE SCHEMANAME = 'public' AND RELNAME = 'table_name'

)

  )

  AS BB ON AA.COL_NUM = BB.OBJSUBID ORDER BY AA.COL_NUM;