Report source - test2
- Bob Swift
Owned by Bob Swift
May 02, 2023
1 min read
Loading data...
Example
{sql:dataSource=xxx_biz_view|output=wiki}
SELECT
regexp_replace(table_name, '.*_(.*)', '\1') as "Table"
, table_description(table_name) as "Description"
, '{sql-query:dataSource=xxx_biz_view} SELECT "Column", "Data type", "Nullable" from column_info(''' || table_name || ''') {sql-query}' as "Columns"
, '{sql-query:dataSource=xxx_biz_view} SELECT * from key_column_info(''' || table_name || ''') {sql-query}' as "Keys"
from information_schema.tables
where table_schema = 'public' and table_type = 'BASE TABLE' and table_name not like 'marketplace%'
order by table_name
limit 1
{sql}More text