Schema
public
Owner
albenard
Descriptions
Vue permettant de lister les vues utilisateurs de la base de données
Fields
Name | Data type | Description |
---|---|---|
nom |
name |
|
proprietaire |
name |
|
Rules
Name | Event | Instead | Condition | Description |
---|---|---|---|---|
_RETURN |
SELECT |
|
|
Indices
There are no indices for table v_vue_des_vues
Definition
CREATE VIEW public.v_vue_des_vues (
nom,
proprietaire)
AS
SELECT pg_views.viewname AS nom,
pg_views.viewowner AS proprietaire
FROM pg_views
WHERE pg_views.schemaname = 'public'::name AND pg_views.viewname ~~ 'v_%'::text
ORDER BY pg_views.viewname;
COMMENT ON VIEW public.v_vue_des_vues
IS 'Vue permettant de lister les vues utilisateurs de la base de données';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 26/02/2014 11:51 |