Redshift Observatory

System Table Tracker

System view pg_catalog.stl_datashare_changes_producer version 1.0.51304 / 2023-06-04

schema name column data type
pg_catalog stl_datashare_changes_producer action int4
pg_catalog stl_datashare_changes_producer actiontime timestamp
pg_catalog stl_datashare_changes_producer consumeraccount char(12)
pg_catalog stl_datashare_changes_producer consumernamespace char(128)
pg_catalog stl_datashare_changes_producer datashareobjid int4
pg_catalog stl_datashare_changes_producer datashareobjname char(128)
pg_catalog stl_datashare_changes_producer datashareobjtype int4
pg_catalog stl_datashare_changes_producer dbid int4
pg_catalog stl_datashare_changes_producer dbname char(128)
pg_catalog stl_datashare_changes_producer initial_query_time timestamp
pg_catalog stl_datashare_changes_producer message char(512)
pg_catalog stl_datashare_changes_producer pid int4
pg_catalog stl_datashare_changes_producer shareid int4
pg_catalog stl_datashare_changes_producer sharename char(128)
pg_catalog stl_datashare_changes_producer shareproperty char(64)
pg_catalog stl_datashare_changes_producer sharepropvalue char(128)
pg_catalog stl_datashare_changes_producer status int4
pg_catalog stl_datashare_changes_producer targetroleid int4
pg_catalog stl_datashare_changes_producer targetrolename char(128)
pg_catalog stl_datashare_changes_producer targetroletype int4
pg_catalog stl_datashare_changes_producer userid int4
pg_catalog stl_datashare_changes_producer username char(128)
pg_catalog stl_datashare_changes_producer xid int8

View Text

SELECT stll_datashare_changes_producer.userid,
       stll_datashare_changes_producer.username,
       stll_datashare_changes_producer.xid,
       stll_datashare_changes_producer.pid,
       stll_datashare_changes_producer.initial_query_time,
       stll_datashare_changes_producer.actiontime,
       stll_datashare_changes_producer.action,
       stll_datashare_changes_producer.shareid,
       stll_datashare_changes_producer.sharename,
       stll_datashare_changes_producer.dbid,
       stll_datashare_changes_producer.dbname,
       stll_datashare_changes_producer.targetroletype,
       stll_datashare_changes_producer.targetroleid,
       stll_datashare_changes_producer.targetrolename,
       stll_datashare_changes_producer.datashareobjtype,
       stll_datashare_changes_producer.datashareobjid,
       stll_datashare_changes_producer.datashareobjname,
       stll_datashare_changes_producer.consumeraccount,
       stll_datashare_changes_producer.consumernamespace,
       stll_datashare_changes_producer.shareproperty,
       stll_datashare_changes_producer.sharepropvalue,
       stll_datashare_changes_producer.status,
       stll_datashare_changes_producer.message
FROM stll_datashare_changes_producer


Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers