Schema
Owner
albenard
Descriptions
There is no description for view pollen03
Columns
Name | Data type | Description |
---|---|---|
jointure_pollen |
varchar(50) |
|
commentaires |
text |
|
nb_peres |
integer |
|
Rules
Name | Event | Instead | Condition | Description |
---|---|---|---|---|
_RETURN |
SELECT |
|
|
Indices
There are no indices for table pollen03
Definition
CREATE VIEW public.pollen03 (
jointure_pollen,
commentaires,
nb_peres)
AS
SELECT pollen.recup_pollen AS jointure_pollen,
pollen.commentaire AS commentaires,
pollen.nb_lots AS nb_peres
FROM pollen
WHERE "substring"(pollen.recup_pollen::text, 5, 1) = 'M'::text OR
"substring"(pollen.recup_pollen::text, 5, 1) = 'R'::text
ORDER BY pollen.recup_pollen;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |