pggeodb.nancy.inra.fr/db_toff - db_toff on pggeodb.nancy.inra.fr

View: v_volumetriebase

Schema

public

Owner

albenard

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_mesure_mes
UNION
SELECT 'NB Ensembles Meta'::text AS mesure,
   count(*) AS valeur
FROM t_ens_metadonneee_mesure_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_mesure_caracteristique_mca;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23