db_toff on pggeodb.nancy.inra.fr

View: v_tree_characteristic_abiotic

Schema

public

Owner

postgres

Descriptions

View to produce recursively the abiotic characteristic tree (except the feeding location) / vue permettant de créer récursivement l'arbre des caractéristiques dites abiotiques (parenté avec 'Abiotic environments.' sauf la famille 'Feeding location'.

Fields

Rules

Indices

There are no indices for table v_tree_characteristic_abiotic

Definition

CREATE VIEW public.v_tree_characteristic_abiotic (
   descriptionfamily,
   path,
   char_name,
   char_id)
AS
SELECT v_tree_families_characteristic.description AS descriptionfamily,
   v_tree_families_characteristic.path,
   tr_characteristic_char.char_name,
   tr_characteristic_char.char_id
FROM v_tree_families_characteristic
    JOIN tr_characteristic_char ON v_tree_families_characteristic.id_family =
        tr_characteristic_char.char_fca_id
WHERE v_tree_families_characteristic.path ~~ 'Abiotic environments'::text AND
   v_tree_families_characteristic.description::text <> 'Feeding location'::text
ORDER BY v_tree_families_characteristic.path, tr_characteristic_char.char_name;

COMMENT ON VIEW public.v_tree_characteristic_abiotic
IS 'View to produce recursively the abiotic characteristic tree (except the feeding location) / vue permettant de créer récursivement l''arbre des caractéristiques dites abiotiques (parenté avec ''Abiotic environments.'' sauf la famille ''Feeding location''.';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 19/06/2019 10:17