Redshift Observatory

System Table Tracker

System view pg_catalog.stl_datashare_changes_producer version 1.0.52931 / 2023-07-07

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