db_toff on pggeodb.nancy.inra.fr

View: v_volumetriebase

Schema

public

Owner

postgres

Descriptions

There is no description for view v_volumetriebase

Fields

Rules

Indices

There are no indices for table v_volumetriebase

Definition

CREATE VIEW public.v_volumetriebase (
   mesure,
   valeur)
AS
SELECT 'NB Mesures Traits'::text AS mesure,
   count(*) AS valeur
FROM t_measure_mea
UNION
SELECT 'NB Ensembles Meta'::text AS mesure,
   count(*) AS valeur
FROM t_set_metadata_measure_met
UNION
SELECT 'NB Publications'::text AS mesure,
   count(*) AS valeur
FROM t_publi_pub
UNION
SELECT 'NB Mesures Caracteristiques'::text AS mesure,
   count(*) AS valeur
FROM tj_measure_characteristic_mch;

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