Amazon Redshift
数据库开发人员指南
AWS 文档中描述的 AWS 服务或功能可能因区域而异。要查看适用于中国区域的差异,请参阅中国的 AWS 服务入门

PG_GET_LATE_BINDING_VIEW_COLS

返回数据库中所有后期绑定视图的列元数据。有关更多信息,请参阅 后期绑定视图

语法

pg_get_late_binding_view_cols()

返回类型

VARCHAR

使用说明

PG_GET_LATE_BINDING_VIEW_COLS 函数为后期绑定视图中的每个列返回一行内容。该行包含一个逗号分隔列表,其中包括 schema 名称、关系名称、列名、数据类型和列编号。

示例

以下示例返回所有后期绑定视图的列元数据。

select pg_get_late_binding_view_cols(); pg_get_late_binding_view_cols ------------------------------------------------------------ (public,myevent,eventname,"character varying(200)",1) (public,sales_lbv,salesid,integer,1) (public,sales_lbv,listid,integer,2) (public,sales_lbv,sellerid,integer,3) (public,sales_lbv,buyerid,integer,4) (public,sales_lbv,eventid,integer,5) (public,sales_lbv,dateid,smallint,6) (public,sales_lbv,qtysold,smallint,7) (public,sales_lbv,pricepaid,"numeric(8,2)",8) (public,sales_lbv,commission,"numeric(8,2)",9) (public,sales_lbv,saletime,"timestamp without time zone",10) (public,event_lbv,eventid,integer,1) (public,event_lbv,venueid,smallint,2) (public,event_lbv,catid,smallint,3) (public,event_lbv,dateid,smallint,4) (public,event_lbv,eventname,"character varying(200)",5) (public,event_lbv,starttime,"timestamp without time zone",6)

以下示例以表格式返回所有后期绑定视图的列元数据。

select * from pg_get_late_binding_view_cols() cols(view_schema name, view_name name, col_name name, col_type varchar, col_num int); view_schema | view_name | col_name | col_type | col_num ------------+-----------+------------+-----------------------------+-------- public | sales_lbv | salesid | integer | 1 public | sales_lbv | listid | integer | 2 public | sales_lbv | sellerid | integer | 3 public | sales_lbv | buyerid | integer | 4 public | sales_lbv | eventid | integer | 5 public | sales_lbv | dateid | smallint | 6 public | sales_lbv | qtysold | smallint | 7 public | sales_lbv | pricepaid | numeric(8,2) | 8 public | sales_lbv | commission | numeric(8,2) | 9 public | sales_lbv | saletime | timestamp without time zone | 10 public | event_lbv | eventid | integer | 1 public | event_lbv | venueid | smallint | 2 public | event_lbv | catid | smallint | 3 public | event_lbv | dateid | smallint | 4 public | event_lbv | eventname | character varying(200) | 5 public | event_lbv | starttime | timestamp without time zone | 6