Query: vcn_gateways_table

select
  display_name as "Name",
  'oci_core_internet_gateway' as "Type",
  lifecycle_state as "Lifecycle State"
from
  oci_core_internet_gateway
where
  vcn_id = $1
union all
select
  name as "Name",
  'oci_core_local_peering_gateway' as "Type",
  lifecycle_state as "State"
from
  oci_core_local_peering_gateway
where
  vcn_id = $1
union all
select
  display_name as "Name",
  'oci_core_nat_gateway' as "Type",
  lifecycle_state as "State"
from
  oci_core_nat_gateway
where
  vcn_id = $1
union all
select
  display_name as "Name",
  'oci_core_service_gateway' as "Type",
  lifecycle_state as "State"
from
  oci_core_service_gateway
where
  vcn_id = $1;