Schema
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) |