2 SELECT dropIfExists('VIEW', 'remitto');
3 CREATE OR REPLACE VIEW remitto AS
4 SELECT (SELECT metric.metric_value FROM metric WHERE (metric.metric_name = 'remitto_name'::text)) AS remitto_name,
5 (SELECT metric.metric_value FROM metric WHERE (metric.metric_name = 'remitto_address1'::text)) AS remitto_address1,
6 (SELECT metric.metric_value FROM metric WHERE (metric.metric_name = 'remitto_address2'::text)) AS remitto_address2,
7 (SELECT metric.metric_value FROM metric WHERE (metric.metric_name = 'remitto_address3'::text)) AS remitto_address3,
8 ( (SELECT metric.metric_value FROM metric WHERE (metric.metric_name = 'remitto_city'::text))
10 || (SELECT metric.metric_value FROM metric WHERE (metric.metric_name = 'remitto_state'::text))
12 || (SELECT metric.metric_value FROM metric WHERE (metric.metric_name = 'remitto_zipcode'::text)) ) AS remitto_citystatezip,
13 (SELECT metric.metric_value FROM metric WHERE (metric.metric_name = 'remitto_country'::text)) AS remitto_country,
14 (SELECT metric.metric_value FROM metric WHERE (metric.metric_name = 'remitto_phone'::text)) AS remitto_phone;
16 REVOKE ALL ON TABLE remitto FROM PUBLIC;
17 GRANT ALL ON TABLE remitto TO GROUP xtrole;