View: core.state_scrud_view

Schema	core
Materialized View Name	state_scrud_view
Owner	postgres
Tablespace	DEFAULT
Description

 CREATE OR REPLACE VIEW core.state_scrud_view
 AS
 SELECT states.state_id,
    ((countries.country_code::text || '('::text) || countries.country_name::text) || ')'::text AS country_name,
    states.state_code,
    states.state_name
   FROM core.states
   JOIN core.countries ON states.country_id = countries.country_id;