db_venik
Previous topic Chapter index Next topic

View: flo_localisation_vue

 

 

Schema

public

 

Owner

albenard

 

Descriptions

There is no description for view flo_localisation_vue

 

Columns

Name

Data type

Description

idlieu_loc

integer

 

nom_dept

varchar(80)

 

lieu_dit

varchar(90)

 

ville_proche

varchar(50)

 

latitude

numeric

 

longitude

numeric

 

altitude

integer

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Indices

There are no indices for table flo_localisation_vue

 

Definition

CREATE VIEW public.flo_localisation_vue (
   idlieu_loc,
   nom_dept,
   lieu_dit,
   ville_proche,
   latitude,
   longitude,
   altitude)
AS
SELECT
a.idlieu AS idlieu_loc,
   b.nom_dept,
   a.lieu_dit,
   a.ville_proche,
   a.latitude,
   a.longitude,
   a.altitude
FROM localisation_lieu a
    LEFT JOIN dept_fr_ref b ON a.iddept = b.iddept;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com)
Previous topic Chapter index Next topic