重庆思庄PG数据库分享-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));