Pg中查看视图定义

郑全

比如；我想查看视图：vw_ProcessedBillContent 的内容
先确认一下这个是视图：

select * from pg_class   where relkind='v' and relname='vw_ProcessedBillContent'；

有值，表示可以这个是视图

然后，使用以下语句，查看视图定义：


SELECT pg_get_viewdef('public."vw_ProcessedBillContent"');

或者使用下面的语句进行查询：

SELECT
  table_name AS 视图名,
  view_definition AS 视图定义
FROM information_schema.views
WHERE table_name = 'vw_ProcessedBillContent';



ELECT (a."PatDeptId")::character varying(50) AS "PatDeptId",
    (a."BillReceived")::character varying(50) AS "BillReceived",
    (a."BalancePropCode")::character varying(50) AS "BalancePropCodce",
    (a."BillId")::character varying(50) AS "BillId",
    (a."BillNo")::character varying(20) AS "BillNo",
    (a."BillingDeptId")::character varying(20) AS "BillingDeptId",
    (a."BillingPerson")::character varying(20) AS "BillingPerson",
    (a."PatId")::character varying(20) AS "PatId",
    (a."PatOriginCode")::character varying(10) AS "PatOriginCode",
    (a."PatOriginId")::character varying(20) AS "PatOriginId",
    (a."BillOriginCode")::character varying(20) AS "BillOriginCode",
    (a."BillOriginId")::character varying(20) AS "BillOriginId",
    (a."BillTypeCode")::character varying(10) AS "BillTypeCode",
    (a."BillOldId")::character varying(50) AS "BillOldId",
    (a."BillStatusCode")::character varying(10) AS "BillStatusCode",
    (a."IdentityNo")::character varying(10) AS "标识号",
    (a."PatName")::character varying(10) AS "姓名",
    a."BillingTime",
    a."OccurTime",
    (a."OccurPerson")::character varying(50) AS "OccurPerson",
    b."BillDetailsId",
    b."OriginalBillDetailsId",
    b."OrderId",
    b."ChargesCategoryCode",
    b."ChargesCategory",
    b."ChargesId",
    b."IncomeCode",
    b."ChargesName",
    b."Spec",
    b."Income",
    b."ReceiptfeeCode",
    b."Receiptfee",
    b."Quantity",
    b."Unit",
    b."Price",
    b."Receivable",
    b."Received",
    b."InHospitalBalanceId",
    b."SerialNumber",
    b."InsurancePremiumLevel",
    b."ConvertInpId",
    b."InsuranceApprovalMsg",
    a."BillId" AS "账单ID",
    a."BillStatus" AS "账单状态"
   FROM "ProcessedBill" a,
    LATERAL json_to_recordset(a."BillContent") b("BillDetailsId" character varying(50),
        "OriginalBillDetailsId" character varying(50), "OrderId" character varying(50),
        "ChargesCategoryCode" character varying(10), "ChargesCategory" character varying(50),
        "ChargesId" character varying(50), "IncomeCode" character varying(50),
        "ChargesName" character varying(50), "Spec" character varying(500),
        "Income" character varying(50), "ReceiptfeeCode" character varying(20),
        "Receiptfee" character varying(50), "Quantity" numeric(16,5), "Unit" character varying(10),
        "Price" numeric(16,5), "Receivable" numeric(18,4), "Received" numeric(18,4),
        "InHospitalBalanceId" character varying(50), "SerialNumber" numeric(5,0),
        "InsurancePremiumLevel" character varying(20),
        "ConvertInpId" character varying(50), "InsuranceApprovalMsg" character varying(100));