set search_path to _gb, public;
create or replace view shownodes as
select 'Node ' || no_id as node,  no_comment as comment,
(select case when no_active then ' Is Active ' else 'Is Not Active' end) as active
from sl_node order by no_comment;

create or replace view showpaths as
select 'Node ' || pa_client as "Client Node",
	'Node ' || pa_server as "Connects to Server Node",
	pa_conninfo as "Via connection"
from sl_path order by pa_client;

create or replace view showlisten as
select 'Node ' || li_receiver as "Node", 'Node ' || li_origin as "Listens to ", 'Node ' || li_provider as "Via "
from sl_listen order by li_receiver;

create or replace view showset as
select set_id, set_origin, set_comment, tab_comment 
from sl_set join sl_table on (set_id = tab_set)
order by set_id, set_origin;

create or replace view showsubscribe as
select
	'Set ' || sub_set as "Set",
	'Node ' || sub_provider as "Is Provided By",
	'Node ' || sub_receiver as "Is Received By", 
sub_forward as "Is Forwardable",
(select case when sub_active then ' Is Active ' else 'Is Not Active' end) as "Is Active"
from sl_subscribe;

create or replace view showtables as
select
'Set ' || tab_set as "Set",
n.nspname || '.' || r.relname as "Table", tab_id as "Table Id",
tab_idxname as "Unique Index Name",
tab_comment as "Comment"
from sl_table t JOIN pg_class r ON (tab_reloid = r.oid)
JOIN pg_namespace n ON (r.relnamespace = n.oid)
order by tab_set, tab_id;